Yes it's possible but it's also a sign of bad design... why do you need to create a new table on the fly like this?

When in doubt test... you'd be surprised to see how fast that can run . I know you never HAVE TO use...

You compared exists to left join.

I compared inner join to in. In and exists are not the same type of operators so they can't really be compared. Try...

It's still there if you want to take it on . But with the answer in hand it's a little less interesting

Check out Farrell Keough's answer on the previous page.

I don't wanna seem rude but I either don't understand what you really want to do or you need to learn how to do backups using sql server tools or...

Ya I can figure that, but why would you want to denormalize your model, make it alsmot impossible to maintain, impossible to validate the data and maybe even slow it...

Why don't you just support the site and BUY one instead of sucking up for it???

Here's my humble question. Why do you want to do that ???

It's always more of the same... test all the versions you think may work and see which is fastest.

Here you go :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=201238&p=2

I'll recheck my sources tomorrow .

Why can't you insert the data. And after it's in, call the webservice from the application?

[EDIT]

Finally came to the Carpal Tunnel stage... now I can take my vacations

Even simpler... so I'll agree, again .

3999

You could insert id of the new adresses in the trigger and have some job/service check for new adresses every minute and process them there. How do you calculate...