Viewing 15 posts - 57,481 through 57,495 (of 59,049 total)
This should pass your Use Cases...
--=============================================================================
-- Setup for testing
--=============================================================================
--===== System presets
SET NOCOUNT ON
--===== If the temporary test table exists, drop it
IF OBJECT_ID('TempDB..#Customer') IS NOT...
October 2, 2006 at 8:28 pm
WTH? Why can't you use stored procedures or a UDF? Yeah, I know... "Business Requirement". WHAT is that business requirement?
October 2, 2006 at 7:55 pm
Oh yeah... one other question... are you trying the latest code with the UPDATE/INSERT where there are no SELECTs?
October 2, 2006 at 7:52 pm
I ran into something similar... if you drop and recreate a table, the views associated with that table must be recreated, as well. Are you sure you didn't recreate the...
October 2, 2006 at 7:51 pm
Cluster the IDENTITY column if you wish... the natural key you are inserting to should not be clustered for the very reason you mention.
On the ROWLOCK on the SELECT... go...
October 2, 2006 at 5:48 pm
Why? My last solution has no SELECT whatsoever... ![]()
October 2, 2006 at 5:40 pm
I guess that's where I was going with that, David... I'm trying to stay away from the sub-query and it came out wrong.
October 2, 2006 at 6:53 am
If the ROWLOCK,HOLDLOCK works to keep the PK violations out, that'll work... I was peeling 1 potato at a time
How's the deadlock...
October 2, 2006 at 6:36 am
I'm trying to stay away from SELECT at all, Serqiy... ![]()
October 2, 2006 at 6:34 am
Nice, but if you ever end up with 3 entries for a property, your method won't work. ![]()
But, this will...
SELECT MAX(ID) AS...
October 1, 2006 at 9:23 pm
Greg,
It would appear that your TimeIn column could have the following formats...
6:15 a.m.
12:15 p.m.
6:15 p.m.
12:15 a.m.
The periods in the "a.m." and "p.m." could make this a bugger to convert. Even...
October 1, 2006 at 9:20 pm
The way you indent on this forum is to use leading spaces or use the "Increase Indent" tool at the top of the message box when you are creating your...
October 1, 2006 at 8:36 pm
Ok, Lisa... you just assumed that I knew you were talking about the "other" code in your rule of thumb and I thought you were talking about the code I submitted...
October 1, 2006 at 1:04 pm
1. The order will almost always be determined externally to this expression anyway, since unless you can guarantee < 12 months and all in the same calendar year you might...
October 1, 2006 at 11:28 am
Viewing 15 posts - 57,481 through 57,495 (of 59,049 total)