You haven't provided much detail, but would something like this work?SET XACT_ABORT ON -- either use this setting or handle errors for the INSERT in your code

BEGIN TRAN

INSERT INTO DB2.dbo.TargetTable...

This should get you started. You'll need to tweak it, even if only to get the 0 for the first date.WITH NumberedDates AS (

SELECT

Customer

,PurchaseDate

,ROW_NUMBER() OVER (PARTITION BY Customer ORDER...

Are the two tables in the same database? If so, have you considered putting the INSERT and UPDATE statements in a transaction?

John

Perhaps the statistics on your tables are out of date. Try updating them with FULLSCAN.

John

Have a look at this article[/url]. It should help.

John

I can't see any value in backing up a database that is a copy of another database that's already being backed up.

Also, are your backup files really on the same...

That's all a bit vague, although if I had to guess I'd say that you're missing some parentheses around your AND and OR conditions. ANDs are evaluated before ORs...

A UNC path starts with a double backslash.

John

H:\ isn't a network share - it's a mapped drive. Drives that you have mapped are visible only to you, not to the SQL Server service account. Try...

What do you get if you run this?EXEC xp_cmdshell 'dir C:\Users\moody\Desktop\api.json'John

You've lost me, I'm afraid. Please will you post the whole statement and the whole error message?

Thanks

John

Here's one way of doing it:WITH SecurityExamples (Line, Value) AS (

SELECT 1, 'G H2' UNION ALL

SELECT 2, 'G-M3' UNION ALL

SELECT 3, 'G U4' UNION ALL

SELECT 4, 'G-X2' UNION ALL

SELECT 5,...

Something like this:

IF EXISTS (

SELECT ID

FROM Inserted i

JOIN Deleted d ON D.ID = I.ID AND D.Department <> I.Department

)

BEGIN

<Your INSERT statement here>

EXEC sp_send_dbmail <mail parameters here>

END

John

Use the Inserted virtual table to compare the value of Department before and after, and only insert those rows where it differs.

John

Yes. See you there!

John