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,333 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,335 reads
Blogs
Sorting in Stored Procedures – Food for Thought
We know that sorting can be one of the most expensive things in an...
Insperation
Inspiration: The process of being mentally stimulated to do or feel something, especially to...
Trace Query in Extended Events
The ability to quickly and easily trace a query is important to database professionals....
Forums
Replication causing log bloating
Hello, We've had a replication process in place for several years. It seems like...
How to import Excel with XML
Hi, I have an Excel sheet that I have to import into SQL Server....
Recursive CTE - Batches
Hi Folks I'm trying to group rows into batch and adding batch to query...
Ask SSC