Using Comments to Quickly Test CTEs
A quick tip for using a combination of block and line comments to test CTEs
2014-11-10
7,336 reads
Carl P. Anderson
Concatenating Rows
Often in database design we store different values in rows to take advantage of a normalized design. However many times we need to combine multiple rows of data into one row for a report of some sort. New author Carl P. Anderson brings us some interesting T-SQL code to accomplish this.
2011-03-04 (first published: 2009-10-14)
148,451 reads
Blogs
Daily Coping 9 Apr 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Webinar: How to unlock the value of frequent deployments
By Steve Jones
I’m doing a webinar next week, on Wednesday, April 15, 2020, that looks at...
SSMS 18.5 Fixes from Redgate
By Steve Jones
I wrote yesterday about the issues with SSMS 18.5 and some of the add-ins...
Forums
ALWAYS On Setup problem
While configuring N1 and N2 Nodes connected to DC Domain Controller working fine. Establishing...
Do You Have a Mentor?
Comments posted to this topic are about the item Do You Have a Mentor?
Counting Rows in DAX
Comments posted to this topic are about the item Counting Rows in DAX
Ask SSC