tricky query

mrpcguy · #1 (**permalink**) 12-16-11, 03:22

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

Wim · #2 (**permalink**) 12-16-11, 06:15

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

mrpcguy · #3 (**permalink**) 12-16-11, 07:24

seems to work fine, thx

Internet Services

Web Development

Digital Marketing

Consumer Tech