Results 1 to 13 of 13
  1. #1
    Join Date
    Sep 2003
    Location
    Raleigh, NC
    Posts
    183

    Unanswered: multiple criteria in WHERE clause (was "T-SQL")

    How can you handle multiple criteria query in T-SQL ? i wrote selection query and in my where clause i have about 7 different criteria and for some reason when i run the query i do not get any error but i do not get any data return.

    So is there any other way to handle multiple criteria in T-SQL ?
    Last edited by Skharva; 10-05-05 at 14:28.
    Skharva

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Uhmm...how do you ever expect Field1 to equal 1 AND equal 2 at the same time? Curious mathematical alternate universe you live in, but since your server seems to be bound to this particular reality, I suggest you look up the "OR" clause in Books Online.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Sep 2005
    Posts
    161
    Maybe you can put this statement inside of a loop and run it until @@rowcount > 0. If it runs long enough, math rules might change to include an uncertaintly principal where a finite object can have more than one value at one time. Just an idea.

  4. #4
    Join Date
    Sep 2003
    Location
    Raleigh, NC
    Posts
    183
    blindman,

    Actual Field1 is the QuestionID and Field2 is the Answer

    Basically one question would have 5 different choice of ans

    Ex: Question1 Ans: Excellent, Good.....etc

    So i need to say in my query that return all rows where QuestionID 1 has Excellent QuestionID2 has Excellent
    Skharva

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Breaking out the crayons today...
    Code:
    WHERE	(dbo.Field1= 1 AND Field2= 'Test')
    	OR (dbo.Field1= 2 AND Field2= 'Test')
    	OR (dbo.Field1= 3 AND Field2= 'Test')
    	OR (dbo.Field1= 4 AND Field2= 'Test')
    	OR (dbo.Field1= 5 AND Field2= 'Test')
    ...which is logically equivalent to:
    Code:
    WHERE	dbo.Field1 = IN (1, 2, 3, 4, 5) AND Field2= 'Test'
    ...I smell an MS Access GUID addict who thinks every new line is a separate predicate. You need to read up on SELECT statements in Books Online before you go any further with SQL programming.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Sep 2003
    Location
    Raleigh, NC
    Posts
    183
    blindman,

    No, i'm not breaking the Crayons today :-)

    I understand what you are saying in your query but in my case it won't work since i'm trying to find all questions which has answer = Excellent.

    This is how the questions are ask
    Question1 :..............?
    Ans: you are given five diff choice and ask to choose one
    Skharva

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Dude, I see references to "Field1", "Field2", 1, 2, 3, 4, 5, and 'test' in your query. Nowhere do I see any reference to 'Excellent'. It is also becoming more and more obvious that you have not even tried to figure this out yourself using the resources available in Books Online. So either do a little more research, or state your question more clearly.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Sep 2005
    Posts
    161
    This query is obviously the output of a tool like Access. The solution in SQL would be simple. It's time to take the leap from GUI created logic to writing your own SQL. You will be glad after the initial learning curve.

    OR

    You could jump over to the Access forums and get better help.
    Last edited by cascred; 10-05-05 at 13:13.

  9. #9
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    No, I don't think this is direct Access output, because it doesn't make syntactical sense. I think it is the output of someone who thinks that if they format their SQL statement to LOOK like the Access Query GUI grid it will behave like an Access Query.
    Regardless, it's time to either take off the training wheels or hire a chauffeur to drive you around. Books Online.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  10. #10
    Join Date
    Sep 2003
    Location
    Raleigh, NC
    Posts
    183

    Thumbs down

    blindman,

    Thanks for your help. I figure it out.

    And for your quote " it's time to either take off the training wheels or hire a chauffeur to drive you around."

    I think u need to take your quote for ur self since i figure out the query without online book reference.
    Skharva

  11. #11
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1

    Thumbs down

    Well, gosh, how great for you. Maybe next time you can do that BEFORE posting such a simplistic question.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  12. #12
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Do I have to send you to your rooms?

    Good Lord.

    Dude, did you read the sticky at the top of the forum? It would really help us if you follow that model....

    Blind dude...at least buy them dinner first.....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  13. #13
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Heck no, it's dutch or nothin'.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •