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

Scripts by William Mendoza

SQLServerCentral.com profile

   Items 1 to 4 of 4   
 

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: coalesce
Rating: |  Discuss |   Briefcase | 5,964 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 | 945 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 | 879 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,771 reads
   Items 1 to 4 of 4