Viewing 15 posts - 46 through 60 (of 94 total)
Thanks to everyone, especially Matt, Grant and Jeremy.
The OUTPUT works.
February 1, 2008 at 8:13 am
Thanks,
But when I coded OUTPUT INSERTED.KEYID,
...
February 1, 2008 at 7:47 am
The child table has a foreign key ( which is the KeyID system generated on T1).
The KeyID will get populated only after the first mass insert is completed and cannot...
January 31, 2008 at 7:20 pm
We have not gone live yet. Still in the setup phase this week. We will find out if there is any performance issues soon. Thanks
January 25, 2008 at 8:18 am
Thanks! That article is very useful.
January 22, 2008 at 9:56 am
Thank you both, Gail and Antonio. Works fine.
January 21, 2008 at 8:31 am
More information on my query:
Tab1: I query by account. An Account has an average of 1000 POs.
Tab2: Company inventory POs ( about 2 millions POs)
I am doing...
January 8, 2008 at 8:43 am
Thank you so much for the help. That works!
January 7, 2008 at 9:01 pm
Thanks, Steve. I will give it a try.
December 27, 2007 at 10:13 am
Thank you, Gail. Works like a charm.
December 8, 2007 at 9:03 pm
Hi Steve,
Does you query often use the audit_output in the result set? Yes
These are the queries(from most frequent to least frequent):
1. Administrators sit at their computers, run the...
December 7, 2007 at 9:20 am
Thank you both for the suggestions.
As for queries, they are based either on server or both parms - by customer name and server.
I am a novice and have a minimal...
December 7, 2007 at 7:00 am
Thank you, anteres686. That is cool. So far it works.
November 5, 2007 at 8:20 pm
I found the answer
SET @SQL = .... ' + CAST(@Status AS VARCHAR(10))
Thanks
October 29, 2007 at 8:49 am
Viewing 15 posts - 46 through 60 (of 94 total)