Posted by Peter Nurse on 11/21/06 19:49

Thanks, Uri.

I think what you're saying (and I'm discovering!) is that I'm stuck
with my (perceived) problem.

A friend has made the best suggestion yet:-

How about using a single table with guid, username or SPID
to provide that separation?

Then it becomes a simple delete/insert to update the data.
As an added bonus having a permanent table means that
you can take advantage of all the good things like indexing and
statistics.

Thanks for your help!

• Next in forum: Re: Help with a complex UPDATE query
• Prev in forum: Database Cloning
• Thread view: Re: Default Table Owner using CREATE TABLE, INSERT, SELECT & DROP TABLE

[Reply to this message]