Results 1 to 3 of 3

Thread: tricky query

  1. #1
    Join Date
    Mar 2004
    Posts
    162

    Unanswered: tricky query

    edit:
    i got stuck with a query that mess up my head

    I have a column in a table that contains 0, 1 and NULL. Datatype is BIT.
    Furthermore i got a variable with value either 0 and 1 from a webform.

    What i need to do is to compare those values and make a WHERE statement like this:
    if variable =0 show rows with 0 and 1
    if variable =1 show rows with only 0


    thx in advance //Mr
    Last edited by mrpcguy; 12-16-11 at 06:17.

  2. #2
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    This should work:
    Code:
    DECLARE @Variable int
    SET @Variable = 0
    
    SELECT @variable as variable, * 
    FROM #DaTable
    WHERE (
    	(@variable = 0 AND aColumn IS NOT NULL) 
    		OR
    	(@variable = 1 AND aColumn = 0)
    	)
    
    SET @Variable = 1
    
    SELECT @variable as variable, * 
    FROM #DaTable
    WHERE (
    	(@variable = 0 AND aColumn IS NOT NULL) 
    		OR
    	(@variable = 1 AND aColumn = 0)
    	)
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  3. #3
    Join Date
    Mar 2004
    Posts
    162
    seems to work fine, thx

Posting Permissions

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