Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Bernabe Diaz

SQLServerCentral.com profile

   Items 1 to 9 of 9   
 

Manipulate Horizontal Hierarchy with UNPIVOT

Convert Horizontal Hierarchy to vertical Hierarchy.  Read more...
By Bernabe Diaz 2012/12/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 943 reads

Print Text Month Calendar

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.   Read more...
By Bernabe Diaz 2012/11/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,621 reads

Get a range of numbers

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..  Read more...
By Bernabe Diaz 2012/10/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,132 reads

Another way to get a table list from a string

I prepared this version (my original did not used XML) By being helped by forums feedback from SQL central Forward it to yours peers.  Read more...
By Bernabe Diaz 2010/06/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,432 reads

Another way to split a recordset

Result set splitter with NTILE() function  Read more...
By Bernabe Diaz 2010/04/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,770 reads

t-sql first last day date of the month

Returns the First or last day date of the month for a given date.  Read more...
By Bernabe Diaz 2009/12/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,736 reads

syscolumns names

get a list of syscolumns names from string comma separated columns list  Read more...
By Bernabe Diaz 2009/12/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 696 reads

Split by a row (count) number of a query results

Query results splitter  Read more...
By Bernabe Diaz 2009/05/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,873 reads

Job Report on SQL 2005

get a job report on a server from T-SQL  Read more...
By Bernabe Diaz 2009/04/10 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,852 reads
   Items 1 to 9 of 9