Thanks. I'm sorry, I should have added this code after the example code I included in my post.

select *

from #tbl_casualty

In the SSMS example, I get data back....

A big thank you to everyone who looked at this and responded back A collegue of mine found out that I had a problem and was able to solve it....

Edition ProductVersionProductLevel

Developer Edition10.0.2531.0SP1

Thanks for your help

I am an end user. Where can I find the version infoprmation you request?

Thanks for the responses. Here is the error message and code.

When I comment out all but 10 when statements,it works.

Msg 8180, Level 16, State 1, Line...

Some are temperary and some are permanent

For example, I have several table drops to make and the top of my program is getting cluttered which is where I put all of my table drop code. I...

Thank you!

Column_name Data_type Maximum Length

and the rest of it is blank.

Is there a way of displaying column names and data types from a table?

Thank you so much. Now if I can piggyback a followup question about the same temp file...

I wanted to pull a list of column names from my temp file...