tirsdag den 22. december 2015

Case Qhen instead of If else Null

CASE WHEN B.[STAT] IS NULL THEN (C.[EVENT DATE]+10)   -- Type DATETIME
     ELSE '-'                                         -- Type VARCHAR
     END AS [DATE]

Ingen kommentarer:

Send en kommentar