Csv files must frequently be joined. It would be fantastic if we could connect CSV files using the power of SQL. This script accomplishes that.
2023-09-18 (first published: 2023-08-28)
Very often there is a need to create test data manually. This script will provide a mix of names that will make more sense rather than randomly generating meaningless names.
2023-09-11 (first published: 2023-08-24)
This script creates an external table in Synapse.
2023-08-21 (first published: 2023-07-26)
I prepared this version (my original did not used XML)
By being helped by forums feedback from SQL central
Forward it to yours peers.
2023-07-18 (first published: 2010-05-13)
Result set splitter with NTILE() function
2023-07-18 (first published: 2010-03-18)
If you need to get a range sequence of numbers this script can help you to acomplish it. For example : the sequency of numbers between -5 and 5 or 1 and 200, etc..
2023-07-18 (first published: 2012-04-23)
get a job report on a server from T-SQL
2023-07-18 (first published: 2009-03-13)
Convert Horizontal Hierarchy
to vertical Hierarchy.
2023-07-18 (first published: 2012-12-04)