Use of If Else

• Jones'e

  Right there with Babe

  Points: 774

  More actions

  March 10, 2006 at 8:33 am

  #93438

   Can you use a IF Else statment in aggregate function such as

  Round(Sum((rcitem.fqtyrecv - If is null dt.qtyfail O else dt.qtyfail end) * rcitem.fucost), 0) as PartCostTot

  Or how might I preform such a test?

  Thanks in advance!

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  March 10, 2006 at 8:48 am

  #626004

  you don't need to cross post. people usally follow items in all forums

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=264864

   

• Jones'e

  Right there with Babe

  Points: 774

  More actions

  March 10, 2006 at 10:23 am

  #626037

  Ya I know I though this was the best place, not the programming forum. Thanks!