Browse by Tags

Functions to Work with NULL Values

Today I was asked what was the replacement for the IIF command in MS Access and how to manage nulls in SQL Server. So I decided to write about nulls, not that I like to work with them...but sometimes we don't have a choice ;) SQL Server may generate unexpected results when performing calculations...

Posted to MS SQL Dev (Weblog) by Eric Vaillancourt on Thu, Apr 3 2008
How to combine multiple rows of data on same line.

I’m often ask how combine information on same line in a query. Let me explain, lets say that you would like to list all products from the Production.product table in the AdventureWorks database and that you would like to list ALL vendors for each product from the Purchasing.Vendor table on the same line...

Posted to MS SQL Dev (Weblog) by Eric Vaillancourt on Mon, Mar 31 2008

Page 1 of 1 (2 items)