Viewing 8 posts - 1 through 9 (of 9 total)
Works perfectly. Thanks!
February 7, 2009 at 11:03 am
bleh. I changed the COUNT to (R.AnswerID) and it worked fine. Thanks a billion, although I still have little idea what it's doing... if you could clear that up for...
May 28, 2008 at 1:30 pm
I'll admit to having very little clue what's going on there... but it returns a count of 1 for Not Satisfied, where it should be 0...
May 28, 2008 at 1:27 pm
Ahh.. SurveyChoices.QuestionID binds to SurveyQuestions.QuestionID.
May 28, 2008 at 1:05 pm
The link is through the Results table... actually, all of it is based on the results table. I'm honestly not even sure what's going on with this anymore...
May 28, 2008 at 12:48 pm
I gave that a try, but now it returns total results that are way off from what I need... And by way off, I mean the results *should* be 'Not...
May 28, 2008 at 11:46 am
AnswerID will never be null. AnswerID is an index that looks up against SurveyChoices. Maybe I didn't make the layout totally clear... wouldn't be the first time...
Using the parameters I...
May 28, 2008 at 11:27 am
And where would be appropriate? I'm a bit of a T-SQL noob.. my supervisor usually handles most of the complex SQL stuff, and I do all the .NET development work...
May 28, 2008 at 9:22 am
Viewing 8 posts - 1 through 9 (of 9 total)