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,382 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)
150,145 reads
Blogs
T-SQL Tuesday #174 – My Favorite Interview Question
By Steve Jones
This month is a great topic to me. I think growing and improving your...
T-SQL Tuesday #174: Job Interview Questions
By Brian Kelley
Once upon a time, I used to think of difficult technical questions to ask...
Power BI: Refreshable Excel Files in PBI Service
By DataOnWheels
Ever since Excel made its debut in the 1980’s, it has been used as...
Forums
Help on grouping to sets of rows in my sql data
Hello I need help on writing this query. This is what i need. I...
SSIS Connecting to Azure SQL Managed Instance w/ MFA
We've been testing out Azure SQL Managed Instance and created SSIS packages to run...
Summarizing Raw Sales Data with Group Summaries and Final Summary
Greetings, I need to transform data returned in a query from several tables as...
Question of the Day
The Query Traceflag
If I want to enable a trace flag for a specific query, how do I do it?
See possible answers