If you wish to delve into semantics, I suppose you are correct. Still, you didn't meet the spirit of the original posting nor have any of the 23 posts you've...

In order to use non-local UNC's, the server services must start with a windows login that has access to the UNC's desired.  Our DBA's setup a special "SQLDBA" user (with...

Sreejith,

Good code but if you run it more than once, it inserts additional new "Expired" records for the same ticket(s) that already have "Expired" records... you forgot to check to...

An hour for 30k records?  Obviously, that's not good... I'm thinking that the ORDER BY is what is really slowing things down but I could be wrong... the UNIQUE IGNORE DUPLICATE...

That's one of the things I admire about you, Remi... absolute integrity and honesty...

Here's a couple of links I was involved with that explain it all...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=243646&p=2

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=1073&lngWId=5

Absolutely correct, Remi... you and I both know that "open text" columns that contain multiple pieces of data (city,state... full name, etc) are the absolute worst and will usually require...

It means the deadlock occurred on an Index level rather than a table or a page...

You don't need dynamic SQL for this...

drop table #test

CREATE TABLE #Test( FieldOne varchar(10),

                                   FieldTwo integer)

DECLARE @Parameter1 integer

SET @Parameter1 = 1

INSERT INTO #Test

SELECT 'Test...

There's several ways to do this... here's one if you have SA privs... there are other methods if this one doesn't suit ya... let us know...

DECLARE @Cmd VARCHAR(8000)

SET @Cmd =...

Are you talking about having SQL Server send email?

Naga's update is good and nasty fast... it just needs a filter...

update Customer

set address = LEFT (address, LEN(address) - CHARINDEX(',', REVERSE(address)))

WHERE LEN(Address) - LEN(REPLACE(Address,',','')) = 2

Don't forget that ISNUMERIC sometimes allows an "e" or "d" and will also allow decimal points and dollar signs and etc, etc....

The method Ken uses is nasty fast and is...

First of all, you shouldn't be inserting "Owner" into the Audits table because that's a form of denormalization you don't need here... bit, if you insist, here's a self supporting...

Good tool... bad answer ... you still haven't answered the "generic" question.  David got it, though...

(and it appears that you are not paying for this form of advertising which might...

 SELECT i.*

   FROM IndSales i

   LEFT OUTER JOIN mstBranch b

                ON i.BankCode   = b.BankCode

               AND i.BranchCode = b.BranchCode

  WHERE b.BankCode IS NULL