Notes on SQL

Random articles from a puzzled DBA

One of the most useful commands of late to myself is Pivot, introduce in SQL 2005. It is also one of the many commands which I completely fail to recall the syntax of. It sits in the dark room of ‘vague recollection’ in the further recesses of my mind, keeping company with Row_Number, pretty much …

Continue reading