Viewing 2 posts - 1 through 2 (of 2 total)
Look into Pivot Table conecpts in Books Online for SQL. You will get a fair idea on converting rows to columns. Also look at CUBE and ROLLUP operators for more...
July 28, 2005 at 4:43 am
#577814
Look at the detail description and options available like InstanceName, MachineName and ServerName for SERVERPROPERTY property....
July 13, 2005 at 1:54 am
#573783