Viewing post 1 (of 2 total)
CASE
WHEN LT.SourceType = 'M' AND MO.SystemType = 'I' THEN 'Issued'
WHEN LT.SourceType = 'M' AND MO.SystemType = 'C' THEN 'Completed'
ELSE 'N/A'
END AS 'MOStatus'
August 25, 2010 at 5:43 am
#1211551