Query to Excel Stored Procedure
Transform your query result into an Excel file using this technique.
2018-03-05
2,502 reads
Darko Martinovic
2017-07-07
1,058 reads
Practical usage of SQLCLR: Building QueryToHtml function
This article shows a few techniques with SQLCLR to to transform a query result into HTML.
2017-06-05
2,529 reads
How to Capture Deleted Records
This article shows a few techniques that help in capturing deleted records.
2016-12-19
3,036 reads
Blogs
Information Measurement with SQL Server Part 4.5: The Squared L2 Family of Distances
By Steve Bolton …………In the last two installments of this series of amateur self-tutorials...
Security Learning Pathway at PASS Summit.
This year PASS is trying something new at PASS Summit. There are going to...
Pathways to Progress
One of the most significant and hardest challenges we face as data professionals (or...
Forums
error Output File cleanup does not delete files script d'olla
Hello everyone, I use olla scripts in my backup and maintenance operations there is...
Help with a stored procedure
I have a table "Mytable" containing a list of IDs. There is a web...
Need to perform leaf level aggregation
So I have a DW with a table with some pre-aggregated scores (not my...
Ask SSC