SQL Query
-
I have a Table done is SQL 2000, and Im using ASP.net to program.
Draw Table.
Here are the colums below
DRAW_ID
DRAW_DATE
DRAW_NUMBER1
DRAW_NUMBER2
DRAW_NUMBER3
DRAW_NUMBER4
PRIZE_1
PRIZE_2
PRIZE_3
CREATE_DATE
UPDATE_DATE
I've actually have a page done in asp.net, where it will insert values into this Draw Table. So my DRAW_ID,DRAW_DATE,PRIZE_1,PRIZE_2,PRIZE_3,CREATE_DATE has some values.
Now I'm stuck. Since on another Page of my Site, I need to populate my Dropdownlists with DRAW_IDs. Since Im going to Generate some Lucky numbers and Store them
I do not know how to Query?. Since I need to Get All the DRAW_IDs which does not have any DRAW_NUMBERs...
Please help me out.
-
Are the DRAW_NUMBERs null? And do you need all of them to be null? Then try this:
select DRAW_ID from [Draw table] where
DRAW_NUMBER1 is null or
DRAW_NUMBER2 is null or
DRAW_NUMBER3 is null or
DRAW_NUMBER4 is null
-
Thanks it worked...
-
Raj if I read your original post correctly you want all the Draw_IDs where there are no values for any of the Draw_Nubers. Then using or in your select will not give you the results you want. Try this query
--if object_ID ('TEMPdb...Test') > 0
DROP TABLE Test
Create table Test
(
Draw_ID int identity(1,1),
Draw_Number1 int,
Draw_Number2 int,
Draw_Number3 int,
Draw_Number4 int,
Some_value int
--other stuff
)
insert into test(draw_number1,some_value) values(234,99)
insert into test(draw_number2) values(254)
insert into test(draw_number3) values(232)
insert into test(Some_value) values(99)
select * From Test
Where draw_Number1 is null
and Draw_Number2 is Null
and Draw_Number3 is Null
and Draw_Number4 is Null
--Returns Draw_ID 4
select * From Test
Where draw_Number1 is null
or Draw_Number2 is Null
or Draw_Number3 is Null
or Draw_Number4 is Null
--Returns Draw_IDs 1,2,3,4
HTH Mike
-
Mike, you are probably right
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply