Wonderful...I'll have to look into the possibility of putting the data in a delimited format. I'm not sure exactly how I can go about doing that, but I have...

I appreciate your feedback, but it's not that simple. We have a third-party application that does not support 2005. I understand this isn't the ideal situation, but sometimes...

Do you know how I would go about getting the data from the temp table to use as an input parameter for sp_xml_preparedocument.

That's in the works for the future, but not soon enough...

I'll have to look into it to see if I can determine how it is getting into the table.  It's being stored real-time through a web app, so I don't...

It's a third-party app.  It's kind of a black box, so I don't know their process.  Regardless, it's sounding like this is a much bigger challenge than I expected.

Thanks for...

Unfortunately, that's not an option.  I can't modify the data model/application.

The value is ultimately being used in an OPENXML function, so I need a way to pass it into SP_XML_PREPAREDOCUMENT.

I haven't figured out how to do that yet.....do you have...