Creating a deep hierarchy with FOR XML
I have two tables in an application that I support. One is called [Report], and the other is [ReportParameter].
--SAMPLE...
2011-01-27
18,556 reads
I have two tables in an application that I support. One is called [Report], and the other is [ReportParameter].
--SAMPLE...
2011-01-27
18,556 reads
I love MERGE. You know all those awful IF BEGIN END ELSE BEGIN END blocks you need to write for...
2011-01-17
4,062 reads
I was just refactoring a server-side control and ran into some horrible code. Basicaly there was a big listbox that...
2010-12-30
3,099 reads
I recently was working on a library to manage reports in an application (probably a good candidate for an open source project)...
2010-12-29
663 reads
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
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...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
I've tried different credentials, target server versions, etc. hitting our Primavera WSDL. Works great...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers