Not sure about the portability of INFORMATION_SCHEMA views.  Worked with Oracle for a year and never saw them there, not even a mention in the documentation I had.  Maybe I...

This is what failing to help us help you looks like.  Without seeing the query, the format file, and the data file (with sample data, not live data) all you...

Would help to see the stored procedure as well as who is creating the procedure and the permissions it is using.

Okay, apparently things aren't quite ready for me in the lab.  Just tested your code and it looks like it will give me just what I need based on the...

I could really use some help here.  Not having a lot of luck on my own or finding anything close on the internet.

You'd think he'd know more since it appears he has been working with SQL Server for at least 9 years.  Should have picked up something hanging around here that long.

Please post the DDL (CREATE TABLE statement) for the table(s) involved, sample data (INSERT INTO statements) for each table that is representative of your problem domain (and should exhibit the...