Retrieve Records with NOT NULL

• prakashdotc

  Ten Centuries

  Points: 1165

  More actions

  December 4, 2009 at 3:09 am

  #98424

  Hi All,

  I have a OrderDetails Table with SINumber as Column in it.

  ID is Identity field in the OrderDetails table.

  So new ID for each item with same order number as given below

  Order Details Table

  ID - OrderNumber - ItemCode - SINumber

  1 - 122 - 1 - 223

  2 - 122 - 2 - 224

  3 - 122 - 3 - NULL

  4 - 123 - 4 - NULL

  5 - 124 - 2 - NULL

  6 - 124 - 4 - 228

  7 - 125 - 3 - NULL

  8 - 125 - 5 - NULL

  9 - 125 - 6 - NULL

  From this table i have to get the OrderNumber which has all the SINumber value as NULL

  Need help to do this, thanks in advance. and if i'm not clear please notify me.

  Thanks

  Prakash

• Mark Cowne

  One Orange Chip

  Points: 26952

  More actions

  December 4, 2009 at 3:17 am

  #1087556

  SELECT OrderNumber

  FROM OrderDetails

  GROUP BY OrderNumber

  HAVING COUNT(SINumber)=0

  ____________________________________________________

  Deja View - The strange feeling that somewhere, sometime you've optimised this query before

  How to get the best help on a forum

  http://www.sqlservercentral.com/articles/Best+Practices/61537

• prakashdotc

  Ten Centuries

  Points: 1165

  More actions

  December 4, 2009 at 3:27 am

  #1087561

  Thank U Mark, It Works Fine, Thanks for solving my problem in short period of time.