SQLServerCentral.com Content tagged Advanced Querying, T-SQL Aidshttp://www.sqlservercentral.com/Content tagged Advanced Querying, T-SQL Aids posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Delimited String Parsing Functions - TwoCol setFeed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63962/2008/11/03http://www.sqlservercentral.com/scripts/T-SQL+Aids/63962/Delimited String Parsing Functions - Big2D setFeed it large strings of double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63961/2008/10/22http://www.sqlservercentral.com/scripts/T-SQL+Aids/63961/Delimited String Parsing Functions - Basic SetFeed it delimited horizontal data and it returns it back as a vertical table.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63958/2008/10/20http://www.sqlservercentral.com/scripts/T-SQL+Aids/63958/Delimited String Parsing Functions - 2D setFeed it double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63960/2008/10/14http://www.sqlservercentral.com/scripts/T-SQL+Aids/63960/Delimited String Parsing Functions - Big SetFeed it large strings of delimited horizontal data and it returns it back as a vertical table.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63959/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63959/Counter Table (table of numbers) Setter-Upper for SQL Server 2005Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63957/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63957/Counter Table (table of numbers) Setter-Upper for SQL Server 2000Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.http://www.sqlservercentral.com/scripts/T-SQL+Aids/63956/2008/08/05http://www.sqlservercentral.com/scripts/T-SQL+Aids/63956/BCP Data DynamicallyThis tip will show you how to BCP data out of every table with one command. http://www.sqlservercentral.com/articles/Advanced+Querying/tipbcpalltables/278/2001/06/15http://www.sqlservercentral.com/articles/Advanced+Querying/tipbcpalltables/278/