Thanks Madhivanan, for the kind words! As for the blog, I hope I can continue to write about something or other - work and family and stuff gets in the way and so easy to drop off, you know :)...

ISNUMERIC function has let me down one too many times. But I have learned to work with it so I can get reliable results....

A short powershell snippet to import data from a CSV file to a SQL Server table....

This page describes using Powershell as an alternative to using BCP or SSIS for exporting data from SQL Server to CSV files....

We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...

I am with Manoj on this - it seems easier and more intuitive to use XML infrastructure in SQL to do this. In this specific example the query would be SELECT * FROM testing FOR XML RAW(''),ELEMENTS,ROOT('testing');...

Madhivanan, lots of nice reference material! I very often often google for "Madhivanan+dynamic pivoting" and copy the code from here. I noticed that you don't have a "drop table #pivot_columns" in the code. May not matter because the SQL OS should t...

Madhivanan, lots of nice reference material! I very often often google for "Madhivanan+dynamic pivoting" and copy the code from here. I noticed that you don't have a "drop table #pivot_columns" in the code. May not matter because the SQL OS should t...