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,342 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,833 reads
Blogs
Daily Coping 21 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
It’s 2021, so why are you reading this?
If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....
Daily Coping 20 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
A Beginning Project
Comments posted to this topic are about the item A Beginning Project
Amend a Commit
Comments posted to this topic are about the item Amend a Commit
Save results from Stored procedure to a CSV file.
I have a SqlAgentJob calling a stored proc. that loops through a list of...
Ask SSC