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...
-
BizTalk Developer Interview Questions and Answers : Schema 1. What is the purpose of a document schema? The schema is basically a contr...
-
Qlikview developer, Designer and admin interview questions (Qlikview developer, Designer and admin FAQ’S) 1. Difference between Set ...
-
MVC: Handling Multiple button submission from one view While developing any web applications we use to design lot more forms. Most of...
-
· Include SET NOCOUNT ON statement. · Use schema name with object name. · Do not use the prefix “sp_” in t...