Conditional Select in Calculation

• Mark Cowne

  One Orange Chip

  Points: 26986

  More actions

  February 24, 2009 at 10:23 am

  #949529

  Try using COALESCE

  SELECT

  t1.blah1,

  t2.blah2,

  (t1.field1 * t1.field2)/COALESCE(t2.field3,t1.field4)

  FROM

  table1 t1

  left join table2 t2

  ____________________________________________________

  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