Please see my last response. In your situation you should use Steves example. My SQL example was just that - an example. It doesnt reflect your actual column names.
Jon On Dec 11, 2014, at 8:50 AM, Torrent Girl <[email protected]> wrote: > > 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:359823 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
