hahahahaha

now, this is clear tutorial!

conceptually ok =)

I got 974.6 the second time... since then, no inch more... Call me Grinch, but God, I love to kick Santa!!

=)

Hungarian Notation is critical in long codes. My guess is, this should not be the case in set-oriented store procedures: fewer vars. So, as long as no one takes...

I agree. The second best thing is to use the same owner if dbo is not possible (some peculiar security reason) and stick to it.

Keep it simple if possible.

Do not agree on cluster index; do agree on identity primary key, as a starting point.

Also it's much easier (and this argument was not included in you article) to have...

Sorry my mistake, you need both in the first case!

A HOLDLOCK (also know as SERIALIZABLE) is a proper lock. And UPDLOCK is also correct; you also need an Exclusive Lock,...

A sub query in a EXISTS does not return rows, so the columns list is not relevant. It's just a syntax issue. That’s not the case with the IN case...

The last person needs aditional resources dynamically assigned by the server: locks for example.

I preffer,

DELETE FROM PARTY_COMMENT WHERE exists

(SELECT * FROM PARTY WHERE PARTY.CORRESPONDENCE_ID = @corrid and

PARTY.PARTY_ID = PARTY_COMMENT.PARTY_ID

)

DELETE FROM PHONE WHERE exists

(SELECT * FROM PARTY WHERE PARTY.CORRESPONDENCE_ID = @corrid and

PARTY.PARTY_ID...

This is one of the most interesting topics I've read so far. Thanks Remi!!!.

Sorry I'd missed the original challenge...

Be sure about the datetime format, even if you read in a string, you should (pre) agree, the valid date(s) format(s).

If it differs from the host default datetime format,...

wow! It will work because you are blocking ALL the Table1. A HOLDLOCK would be enough. Your COMMIT/ROLLBACK will release all locks.

For my personal taste, I like identity cols, even...

But even then, maybe a TOP n and a loop over a result set... even using a temp with an identity col and just the primary keys (and not all...

Prefer and IPConfig solution, since you won't depend of a proper sql config. @@servername may not have your server name, for instance.

Just SELECT, no (SELECT ... ) (a former Oracle kid?):

INSERT INTO #SingleHolders

(PolicyHolder, CorrespondenceClient)

SELECT DISTINCT PolicyHolder1, ISNull(CorrespondenceClient, 0)

FROM #PolicyList

WHERE PolicyHolder2 IS Null

ORDER BY PolicyHolder1, ISNull(CorrespondenceClient, 0)

And yes, sorting according to the...