One of the small quirks of SQL is that it can add each row to a variable.In the most common case, this is used to generate a comma delimited list.The script shows how to do this wiht a scalar function, so that multiple rows are returned.The script shows calculating the column sum the hard way […]
2007-03-26 (first published: 2007-03-11)
579 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Sample data: jan 10gb feb 15gb mar 16gb april 14gb(truncate data) may 18gb june...
Everybody (well almost) knows that if you want to learn the design patterns for...
How many table hints can I include in a query?
See possible answers