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.