case statement

• ranuganti

  Ten Centuries

  Points: 1092

  More actions

  May 10, 2012 at 5:08 am

  #260737

  select

  case when Void = 0 then SUM(weight) end AS totalweight

  from test

  when i use this i get

  result as:

  total weight

  NULL

  1.7

  Please help!!

• Kingston Dhasian

  SSCoach

  Points: 19799

  More actions

  May 10, 2012 at 5:27 am

  #1485615

  Duplicate post. Please post your replies here.

  http://www.sqlservercentral.com/Forums/FindPost1297770.aspx

  ---

  Kingston Dhasian

  How to post data/code on a forum to get the best help - Jeff Moden
  http://www.sqlservercentral.com/articles/Best+Practices/61537/