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,772 reads
Result set splitter with NTILE() function
2023-07-18 (first published: 2010-03-18)
2,018 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,384 reads
get a job report on a server from T-SQL
2023-07-18 (first published: 2009-03-13)
2,052 reads
Convert Horizontal Hierarchy
to vertical Hierarchy.
2023-07-18 (first published: 2012-12-04)
1,567 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)
684 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,831 reads
2023-07-18 (first published: 2009-04-28)
3,544 reads
get a list of syscolumns names from string comma separated columns list
2023-07-18 (first published: 2009-11-11)
797 reads
