Viewing 15 posts - 14,926 through 14,940 (of 18,923 total)
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?
July 15, 2005 at 5:31 am
When in doubt test... you'd be surprised to see how fast that can run
. I know you never HAVE TO use...
July 15, 2005 at 5:28 am
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...
July 15, 2005 at 5:25 am
It's still there if you want to take it on
. But with the answer in hand it's a little less interesting
July 15, 2005 at 5:20 am
Check out Farrell Keough's answer on the previous page.
July 15, 2005 at 5:19 am
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...
July 14, 2005 at 8:42 pm
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...
July 14, 2005 at 8:04 pm
Why don't you just support the site and BUY one instead of sucking up for it??? ![]()
![]()
July 14, 2005 at 7:58 pm
Here's my humble question. Why do you want to do that
???
July 14, 2005 at 7:53 pm
It's always more of the same... test all the versions you think may work and see which is fastest.
July 14, 2005 at 7:52 pm
July 14, 2005 at 6:35 pm
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
July 14, 2005 at 3:07 pm
Even simpler... so I'll agree, again
.
3999 ![]()
![]()
July 14, 2005 at 2:59 pm
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...
July 14, 2005 at 2:58 pm
Viewing 15 posts - 14,926 through 14,940 (of 18,923 total)