During my technical career, I’ve changed companies several times. I even worked as an independent contractor for three years. One thing I have never done before was switch departments and roles within one company. That’s about to change in a couple of weeks as I move from Simple Talk Editor and DevOps Advocate in Marketing […]
2022-12-23 (first published: 2022-05-21)
90 reads
A stored procedure that will parse (shred) the contents of any well-formed XML document into a SQL table.
2015-04-08 (first published: 2013-07-09)
4,982 reads
It is simple to parse HTML directly to SQL, manipulate, and render back to HTML using SQLDOM
2019-07-15 (first published: 2012-04-16)
17,451 reads
Parses delimited string into a table of up to 9 varchar fields.
2008-12-17 (first published: 2008-11-10)
2,667 reads
A quick way to check a targeted column for whitespace.
2008-11-06 (first published: 2008-09-12)
936 reads
Feed 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.
2008-11-03 (first published: 2008-08-05)
2,192 reads
Feed 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.
2008-10-22 (first published: 2008-08-05)
1,152 reads
Feed it double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.
2008-10-14 (first published: 2008-08-05)
1,033 reads