This works overall, but not in my case.

For me to get this to work, I would have to know the column names in advance, in this case i don't since...

I knew it was something simple, no more writing code before my morning cup of coffee, thank you .

This was a DOH! moment, I am used to being able to pull my data into my report and build it from there, not having to insert a table and...

I figured it out, when doing a like statement, it's case sensistive :(.

The article will answer my questions, thank you. Sorry for being so vague, typed up the request before heading off to a meeting.

Thank you all, it works now and my bosses are happy, mainly becuase I display the results in Excel and I used 'pretty' colors.  At least I learned a cool new...

Thank you, I knew it was something like that but I could not remember excatly how to do it, this is a really powerful tool, thank you again, it works...

An audit history table is what I am going to have to create.

What I am trying to do run my stored procedures and then go back and we when it...

Lowell,

While I have not done what you are suggesting before, it seems as if I can attempt it.  My question for you is in your code:

BULK INSERT BULKTABLE...

I thought about that, when I tried it initially, I put the DB name first and it errored out, thank you for your advice, it worked perfectly.

I mispoke before, refreshing on the table level works.

Yes, the only thing that I have not tried is the rebooting the system and going from there.

I have gotten side tracked a little on a different part of the same project, my question is what will the short list for tuning actually do?

I have gotten side tracked a little on a different part of the same project, my question is what will the short list for tuning actually do?

Thank you for the advice, I have found the 'problem child' queries and now it's a matter of putting my found skills of indexing and a few other minor things...