I get the following error on Jon's example: Msg 207, Level 16, State 1, Line 2 Invalid column name 'disagree'.
Disagree is not a column. It's the value. > Yes, using Steves example query as a foundation. I assumed you were > using a relational model with separate questions/answer tables but > that is not the case. You wont need joins or conversions. Steves > "Sum(case response = 'agree' then 1 else 0 end) as agree query is > what you are looking for. > > Jon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359822 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
