Browse by Tags

Pivots with Dynamic Columns in SQL Server 2005/2008

Pivots in SQL Server 2005/2008 can convert row into column data. Pivots are frequently used in reports, and are reasonably easy to work with. However, many people have asked me how to make the column list dynamic. Normally, this list is fixed, but many times the new columns are determined by the data...

Posted to MS SQL Dev (Weblog) by Eric Vaillancourt on Sat, Apr 12 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
Scripting Multiple Objects

The other day I found a way to script multiple objects using the "Object Explorer Detail" tab in Management Studio. To be honest, I never thought that this tab was useful. All you have to do is select the type object you want to script in the object explorer and do a multiple selection in the...

Posted to MS SQL Admin (Weblog) by Eric Vaillancourt on Wed, Mar 19 2008

Page 1 of 1 (3 items)