Forum Replies Created

Viewing 8 posts - 1 through 9 (of 9 total)

  • RE: Updating a temp table with a count of occurrances in a different table?

    Works perfectly. Thanks!

    __________________________________
    I went left where the road went right... I kept going when everyone said it was impossible... I defied everything they said couldn't be done...

    And now I'm lost...

  • RE: 4-table join not returning all the data I need

    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...

    __________________________________
    I went left where the road went right... I kept going when everyone said it was impossible... I defied everything they said couldn't be done...

    And now I'm lost...

  • RE: 4-table join not returning all the data I need

    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...

    __________________________________
    I went left where the road went right... I kept going when everyone said it was impossible... I defied everything they said couldn't be done...

    And now I'm lost...

  • RE: 4-table join not returning all the data I need

    Ahh.. SurveyChoices.QuestionID binds to SurveyQuestions.QuestionID.

    __________________________________
    I went left where the road went right... I kept going when everyone said it was impossible... I defied everything they said couldn't be done...

    And now I'm lost...

  • RE: 4-table join not returning all the data I need

    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...

    __________________________________
    I went left where the road went right... I kept going when everyone said it was impossible... I defied everything they said couldn't be done...

    And now I'm lost...

  • RE: 4-table join not returning all the data I need

    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...

    __________________________________
    I went left where the road went right... I kept going when everyone said it was impossible... I defied everything they said couldn't be done...

    And now I'm lost...

  • RE: 4-table join not returning all the data I need

    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...

    __________________________________
    I went left where the road went right... I kept going when everyone said it was impossible... I defied everything they said couldn't be done...

    And now I'm lost...

  • RE: 4-table join not returning all the data I need

    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...

    __________________________________
    I went left where the road went right... I kept going when everyone said it was impossible... I defied everything they said couldn't be done...

    And now I'm lost...

Viewing 8 posts - 1 through 9 (of 9 total)