All

Fixed this by using a simple trigger.

CREATE TRIGGER trg_codes 
ON dbo.codes 
FOR UPDATE, INSERT
AS
 IF EXISTS (
   SELECT ext.[ID]
   FROM inserted ins
    INNER JOIN [dbo].[codes] ext
    ON ext.[Code] = ins.[Code]
    AND ext.[EMail] = ins.[EMail]
    AND ext.[ID]...

Yes I know why.

One of the connections in the package you're running can't access it's specified server. The big give away the message "[ DBNETLIB ] [ ConnectionOpen ( Connect ( )...

It won't fail ... that is the issue. I need to apply a business rule that the same address cannot be assigned to the same code unless its the generic...

But I think more in line with what Carl is trying to produce,

"So as a rule you should avoid using functions"

Sergiy, Hmmm ... the @Array table could have been some bits I didn't cleanup from an earlier revision, the function definitely doesn't...

This is the function I use for splitting values. It takes advantage of a "Numbers" table to provide a set-based query. I suppose the actual query could be used as...

Sergiy, I'm beginning to think that there may be something wrong with the system you're running these tests on.

I ran each of...

Johnny Mnemonic is a short story Gibson wrote before Neuromancer.

http://www.antonraubenweiss.com/gibson/gibson3.html

Coming late to the party here.

Like all suggestions here and agree War Games has to be at the top. Probably because it's something I can relate to

Why not just send a PM?

http://www.sqlservercentral.com/forums/userinfo.aspx?id=150225

You might run into instances of the scheduled job hanging while it's waiting for a user response (who knows what is in the macro that's being run

... or just to be different

DateAdd(hh, -24, GetDate())

Take a look over at http://www.sqldts.com

They have a good article on processing a global variable rowset which should give you the building blocks you need. As suggested you would...

"...Mind i m required to compare only time not the dates and @startTime value is always less than @EndTime value)..."

Given this statement, the data you supplied is incorrect

set @StartTime='12/1/2005 12:30:49...

Why build what has already been built?

Check the websites like http://www.componentsource.com