donderdag, januari 14, 2010

Flip/pivot, combine, concatenate ... data in MS SQL


Having to play with data on my current assignment, amongst others using Microsoft SQL, i sometimes want to combine a number of records in one cell. And i always forget the command that enables you to do that kind of stuff: coalesce.

On this site is a nice article about what you can accomplish with this command. And using your favourite search engine can help you find more information on this usefull command.

Update June 23rd 2010: thought i would remind myself (and tip anyone interested ;-)) here of, if i ever find the time, start reading up on PowerShell; i read it is a welcome tool for SQL DBA's as well.

Geen opmerkingen:

Een reactie plaatsen