Hi,

I have a dynamic sql stored procedure that I have created to create a cross tab report. Of course, as the columns are dynamically created, when creating a tableadapter in a dataset against this stored procedure, I won't get any columns available.

How do I go about this? Is the only way to hard code the column names and do away with the dynamic sql?