Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

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: sql

Rating: (not yet rated) |

Briefcase | 728 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:

|

Briefcase | 1,441 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:

|

Briefcase | 1,069 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:

|

Briefcase | 1,411 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:

|

Briefcase | 1,728 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:

|

Briefcase | 2,633 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:

|

Briefcase | 667 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:

|

Briefcase | 1,664 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:

|

Briefcase | 1,774 reads

Items 1 to 9 of 9