how to assign NULL value in sql server 2008?

Question

Cusid  Cusgroupid  Productid
5      NULL        NULL

ppid   cusgroupid       list    bulk     cost   billing
854    NULL             45.00   42.00    42.00  42.00   
855    2                39.00   36.00    33.00  30.00

I want to compare two table, expect result is

1, if cusgroupid is 2 only select that row

ppid   cusgroupid       list    bulk     cost   billing
855    2                39.00   36.00    33.00  30.00

2, if cusgroupid is null only select that row

ppid   cusgroupid       list    bulk     cost   billing
854    NULL             45.00   42.00    42.00  42.00

Please help!

2 condition is if cusgroupid is NULL only select that row ppid cusgroupid list bulk cost billing 854 NULL 45.00 42.00 42.00 42.00 — jay
– jay, Commented Aug 19, 2010 at 10:29
To be able to help you, we have to understand what you want. I for one don't have a clue, sorry. — Lieven Keersmaekers
– Lieven Keersmaekers, Commented Aug 19, 2010 at 10:30
And this question has already gotten two upvotes, interesting... — ercan
– ercan, Commented Aug 19, 2010 at 11:00

Lieven Keersmaekers · Accepted Answer · 2010-08-19 10:32:18Z

1

Still not quit sure what you need but does this get you any further?

SELECT * FROM YourTable WHERE cusgroupid = 2
SELECT * FROM YourTable WHERE cusgroupid IS NULL

or perhaps

SELECT   * 
FROM     Table1 t1 
         INNER JOIN Table2 t2 
           ON ISNULL(t2.cusgroupid, -1) = ISNULL(t1.cusgroupid, -1)

or

SELECT * FROM YourTable WHERE cusgroupid = 2 OR cusgroupid IS NULL

answered Aug 19, 2010 at 10:32

Lieven Keersmaekers

58.9k15 gold badges117 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jay Over a year ago

in single query i need ... plz

marc_s · Accepted Answer · 2010-08-19 10:56:38Z

0

If you want to have all rows with value 2 or NULL, then use:

SELECT ppid, cusgroupid, list, bulk, cost, billing
FROM dbo.YourTable 
WHERE ISNULL(cusgroupid, 2) = 2

This will select all rows with cusgroupid = 2, and if cusgroupid is NULL, it will also use the value 2 - so those are included as well.

answered Aug 19, 2010 at 10:56

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Collectives™ on Stack Overflow

how to assign NULL value in sql server 2008?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related