Paul, you were absolutely correct!    I did not look at the code thoroughly and did not recognize that. 

That is VERY cool!  Thanks! 

I have not seen that function... 

I would be Libertarian in a nano-second if they would change their stance on abortion.  This is definately not the forum to get into that subject...

It looks as if int_id is a Primary Key.  You could that with a WHILE loop and drop the need for a cursor.  Otherwise, you could make a Identity Field...

Oh man..., of all people to argue this point with...    I love it when you follow my replies and make my code, (or answers)...

I think Judith's code would work for each individual Insert - Tertius may know of further constraints to apply.  It looks like a nice, clean use of CharIndex...

Here is yet another possibility.  Since the other posts taught me you can use @Variable declaration within a Trigger, I used the following approach.  Three major things:  One, I assumed...

This is a tough one. 

I have started something, (using CHARINDEX), but getting past Part2 is proving difficult for me.  I do not write that many Triggers.  Can a stored...

Here is a quick, simplified script, (I am assuming five decimal places will suffice and the length of the values is no greater than ten places): 

DECLARE @OriginalValue varchar(25),

 @Sum...

It sounds to me as if there are two ways to understand this question. 

The basic syntax would seem to me to be:

SELECT * FROM TableA WHERE TableA.IdentityField NOT EXISTS(...

Thanks Frank! 

I did not know that the STR function would handle dates.  Cool!

I cannot get Jeff's solution to work without using GETDATE(). 

SELECT REPLACE( CONVERT( char(6), '20050101', 100),...

Suggestions I found were make sure SQL Agent is running and check your timeout; you may need to increase the length of timeout...

Good hunting...

Just a quick tip: IF EXISTS( SELECT TOP 1 * FROM [vwDups]) will be a bit quicker to check for existence...

Good eye, Vladan!!

Glad to help Cory.  I would highly recommend reading the rest of the post and especially Frank's article.  I plan to read over the weekend.