Best Business School - 2010
Click here
MBA - Business
Friday, November 12, 2010
Thursday, November 4, 2010
NULL condition in CASE statement
The following would NOT work
case when e.myCode = null then e.yourCode else e.myCode end as displayCode
instead use below
,isnull(e.myCode,e.yourCode) as displayCode
hope this helps
case when e.myCode = null then e.yourCode else e.myCode end as displayCode
instead use below
,isnull(e.myCode,e.yourCode) as displayCode
hope this helps
Subscribe to:
Posts (Atom)
