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:
Post Comments (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...
-
.Net Integration with Bill Desk Payment Gateway Introduction: Now-a-days online shopping websites has become very popular, and to h...
-
@foreach (var item in Model), Object reference not set to an instance of an object in MVC Razor ViewIndex.cshtml @model IEnumerable <RazorEngineMVC.Models. User > @{ ViewBag.Title = "Index" ; } < h2 &...
-
Qlikview developer, Designer and admin interview questions (Qlikview developer, Designer and admin FAQ’S) 1. Difference between Set ...
-
. 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 ...
No comments:
Post a Comment