Monthly Archives: October 2012

More on XML and SQL

As mentioned previously Select * from table for XML auto creates one element for each row, with all the values as attributes Select * from table for XML auto, elements creates an XML fragment with a collection of nested elements … Continue reading

Posted in sql | Tagged

Here are your files, and they have CHANGED

I recently had a project to create a comprehensive CSV file of all faculty, with some information.  Same thing for staff.  I opened the user AD group with powershell and collected all the ‘faculty’ OU entries.  With a Directory Entry, … Continue reading

Posted in Uncategorized

SQL select to XML

There are a couple of different ways to deal with getting XML out of MS SQL. A nice post from “beyond relational” by Madhivanan  is this:  The URL is a bit messy. The SQL code is this: (notice if the XML … Continue reading

Posted in sql