SQLServerCentral - Scripts by Bernabe Diaz

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/05/02 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 775 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: (not yet rated) |

Discuss |

Briefcase | 1,366 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,675 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,523 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 | 637 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,606 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,670 reads