SQLServerCentral - Scripts by William Mendoza

Column Headers To Row Headers

How to change from Column Headers to Row Headers Read more...

By William Mendoza 2011/02/24 | Source: SQLServerCentral.com | Category: coalese

Rating:

|

Discuss |

Briefcase | 5,869 reads

OPEN XML Join

This is an example of joining two group nodes using openxml.. In case you have an xml field in the database that you may query Read more...

By William Mendoza 2011/02/04 | Source: SQLServerCentral.com | Category: openxml

Rating:

|

Discuss |

Briefcase | 898 reads

Capitalize the first letter of a sentence

I created this script to capitalize the first letter of a sentence after a space. If no space in your table you may capitalize the first letter after the comma by changing the code. Read more...

By William Mendoza 2009/04/06 | Source: SQLServerCentral.com | Category: string manipulation

Rating:

|

Discuss |

Briefcase | 853 reads

Dynamic table not imposible

I needed to display my data in columns but could not use pivots or cross tables because it wasn't a fix amount of columns. so I created this script, I hope is useful. Read more...

By William Mendoza 2009/02/20 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,726 reads