>>Hi everybody,
>>
>>I want to have a create table script which I can execute multiple times (so I would need to have drop statements first).
>>
>>I also would like to be able to preserve existing data.
>>
>>Is there a way to write such a script?
>>
>>Thanks a lot in advance.
>
>Isn't there something like a temp table in sqlserver ?
Yes, there is INTO statement in SELECT. That's how I'm coding it right now... I just forgot how to check for temp table existance, but I believe we discussed it once with Borislav privately, I need to look.
If it's not broken, fix it until it is.
My Blog