>>>>Where do you have CREATE TABLE #RunSrpt statement?
>>>
>>>Select into - creates the table. There is no specific Create Table command. Why Would you need on?
>>
>>That's the way you're creating temp tables in SQL Server.
>
>Then why after I run the select into #, do I run a select * from # and get results back in sql query window?
>
It works this way too, sorry, my mistake.
If it's not broken, fix it until it is.
My Blog