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
-
The typical way of testing WCF services is to create a test project, add a service reference to the project, and then write a test agains...
-
Qlikview developer, Designer and admin interview questions (Qlikview developer, Designer and admin FAQ’S) 1. Difference between Set ...
-
.Net Integration with Bill Desk Payment Gateway Introduction: Now-a-days online shopping websites has become very popular, and to h...
-
. In the ASP.NET runtime the life cycle of a page is marked by a series of events. In ASP.NET 1.x, based on user interaction a page request ...
-
why use Windows Workflow Foundation? Microsoft has provided this foundation in order to simplify and enhance your .NET development. It is n...