Got it, thanks. File attached.

Okay this is going to sound stupid, but how do I export the table and index info you want from SQL Server 2005? Thank you.

Thanks for the link on how to post. Here is the SQL Execution plan.

-CK

Thanks Dan. Basically all these moving parts are to just create a crosstab result set similar to this:

ANNUAL000000000000000

ANNUAL DOT000000000000000

ANNUAL PHYSICAL000000000000000

BACK UP DRIVER000000000000000

BACK UP DRIVER APPLI000000000000000

BACK UP DRIVER REQUIRED000000000000000

BKUP DRIVER000000000000000

CHANGE...

Technically SQL Server sees it as hard coded, though a few of the dates and ID's are passed in as variables via an application server. (Cold Fusion) This is...