Instead of using long "SELECT ... CASE WHEN ... ELSE ..." construction, you can use the COALESCE function when you need to find a value that is not NULL. Lets review the following T-SQL expression, in which we need to select an available "source":
SELECT TheSource =
CASE
WHEN localSource IS NOT NULL THEN localSource
WHEN intranetSource IS NOT NULL THEN intranetSource
WHEN internetSource IS NOT NULL THEN internetSource
ELSE ''
END
FROM ...
Now lets rewrite the code above using COALESCE function:
SELECT TheSource =
COALESCE(localSource, intranetSource, internetSource, '')
FROM ...
Solution for the QlikView, Biztalk, DotNet and MSBI real time development problems
Search This Blog
Monday, May 4, 2009
Subscribe to:
Posts (Atom)
Popular Posts
-
.Net Integration with Bill Desk Payment Gateway Introduction: Now-a-days online shopping websites has become very popular, and to h...
-
What is "Big Data"? The short answer is that size does matter after all. Sometimes big data is measured in terabytes, petabytes...
-
Use below javascript function to 1) validate the date difference in asp.net 2) difference (number of days, months, years) between two dat...
-
Qlikview developer, Designer and admin interview questions (Qlikview developer, Designer and admin FAQ’S) 1. Difference between Set ...
-
/*If you are facing issues with saving large data into excel * u may get oledbexception like * "The field is too small to accept th...