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)
1,817 reads
Result set splitter with NTILE() function
2023-07-18 (first published: 2010-03-18)
2,063 reads
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)
1,425 reads
get a job report on a server from T-SQL
2023-07-18 (first published: 2009-03-13)
2,084 reads
Convert Horizontal Hierarchy
to vertical Hierarchy.
2023-07-18 (first published: 2012-12-04)
1,620 reads
Some times you need to parse over punch values at the while running a query.
Here is an utility function to help with that task.
2023-07-18 (first published: 2018-10-31)
769 reads
This function return the text format of a month calendar. It could be useful for sending through emails when you do do not have other tools, but T-SQL to send text emails.
2023-07-18 (first published: 2012-10-31)
1,876 reads
2023-07-18 (first published: 2009-04-28)
3,688 reads
get a list of syscolumns names from string comma separated columns list
2023-07-18 (first published: 2009-11-11)
814 reads