So going back to http://benchmarkitconsulting.com/colin-stasiuk/2009/01/14/parsing-xml-into-a-table-structure-possible/ Can it be done? Yes… it’s not pretty but yes it can be done. I emailed this to Brent Ozar to see if he was an XML guru as we had gone back on forth on Twitter about whether or not it’s possible. He pointed me to StackOverflow and 1 [...]
Posts from ‘January, 2009’
WordPress changes my T-SQL code again :(
Sorry for the lack of updates today (and probably tomorrow)… For some reason my single quotes ‘ in my T-SQL code have changed back to grave accents `. I wrote about this a while back http://benchmarkitconsulting.com/colin-stasiuk/2008/11/06/wordpress-messes-up-code-in-blogs-fix-included/ and had to go back and change all my other blog entries and made sure my future ones were good to [...]
Parsing XML into a Table Structure… possible?
Well let me elaborate a bit. The use case (which I’m now hating R.K. for bringing up cause I wont let it go now LOL ) where this applies is…. “I want to insert into a temp table the results of a dynamic sql statement” The caveat being this has to be done WITHOUT knowing [...]
SQL PASS – Edmonton, Canada Chapter
So I’m in the process of starting a SQL PASS Chapter here in Edmonton (for my friends from the south that’s in Alberta Canada ). A friend of mine gave me the idea as I’m starting to branch out more into the SQL social environment and this would be a great way to meet up [...]
70-453 Exam coming up…
http://www.microsoft.com/learning/en/us/Exams/70-453.aspx So I’m writing my upgrade exam for my MCITP-DBA (missed cutoff date for the beta on this one) in a couple weeks and haven’t found much of anything in regards to Microsoft approved practice exams so I guess I’ll be going in blind. With SQL Server’s new aggressive release schedule of a new version [...]
