Viewing 15 posts - 46 through 60 (of 75 total)
Nice introduction. I am sure no offence was intended, and non taken by me.
The example was trivial, but let's wait and see what comes next.
April 14, 2009 at 3:16 am
Amen.
But I'd like to add GOTO to the list of Mr. Simmons. SQL Server 2000 only...
August 12, 2008 at 4:04 am
Oh well, who is John Galt?
November 15, 2005 at 2:01 am
AJ and rsharma, thank you both for your answers. I need the UPDLOCK within a transaction, and will act accordingly.
A small question remains: what is the use of using a...
September 27, 2005 at 12:41 am
A simplified example:
Before the UPDATE of an Order I have to check the Status of the Order(invoiced or NOT invoiced) and the existance of Order Details. Other users should not be allowed...
September 23, 2005 at 6:33 am
Thank you Wanderer, the SQL statement was exactly what I needed!
May 24, 2005 at 1:06 am
Ron,
I knew there wouldn't be an easy solution. I just wanted to know how other developers/DBA's think about the Quick and Dirty solution WITH (NOLOCK).
If anything, this thread confirms...
April 29, 2005 at 12:39 am
Gentlemen,
Of course we won't forget improving the performance. But as the customers add wishes and need more details, the number of tables in frequently used queries is growing. And growing...
April 28, 2005 at 8:32 am
Thank you all for your answers.
I am aware of some of the mentioned issues involved with using WITH (NOLOCK). And I do warn my colleagues not to use this option...
April 28, 2005 at 12:57 am
Jon,
Aha, I see a pattern emerging. I will look for ways to extend your script (because I also need to sum on amounts delivered, amounts invoiced). Couls become quite messy
August 10, 2004 at 4:20 am
Jon,
Thank you for your reply. I am afraid I oversimplified.
I need per order the total amount ordered and the total amount assigned. Product has nothing to do with it, so...
August 10, 2004 at 3:28 am
I go it wrong, but when I created both tables, inserted the data, I noticed that none of the given answers applied.
A is sorted by myIt.Unique_ID desc
B is sorted...
July 27, 2004 at 12:49 am
Gary and Steve,
I should have mentioned that I ran the script in debug mode with AUTOROLLBACK ON. Which, I suppose, is also the answer why @@TRANCOUNT yielded an unlike number....
June 4, 2004 at 4:50 am
Viewing 15 posts - 46 through 60 (of 75 total)