Who is agitated?:-)

GSquared (4/9/2012)

---

Here's what I've used for that kind of thing:

USE ProofOfConcept ;

GO

-- Set up table

CREATE TABLE #T (Col1 CHAR(1)) ;

INSERT INTO #T

...

GSquared (4/9/2012)

---

I'm assuming from the syntax that it's part of a Merge command. If so, it should work. You might need to remove the object-name ("t.") from the...

Yeah, thanks for pointing that out.

What Table.Column should I JOIN ON?

Lynn Pettis (4/7/2012)

---

Trick question. If this is the data/time a record is inserted, why not leave it out of the MERGE entirely and set a default constraint value for...

Could I get a @@rowcount and have a column for DML Indicator, 'Insert or 'Update' and stored that information in the Table?

If I added the column it would be at the end of the table.

I need a way to tract how many Inserts, Updates and Deletes there are for each load...

Don't you perform the initial load to staging. Load the DW Tables, and...

Carlos Bossy (4/7/2012)

---

#2 - Because of #1 I don't care if rows in staging are marked as INSERT or UPDATE. Since we are comparing staging to DW, the ETL...

I kept getting IE Errors and it did not apprear the my question was posted.

Please do not reply to this post.

Please reply to the following:

http://www.sqlservercentral.com/Forums/Topic1279948-363-1.aspx

Lynn Pettis (4/7/2012)

---

Trick question. If this is the data/time a record is inserted, why not leave it out of the MERGE entirely and set a default constraint value for...

I'm wondering if I could add a Column to identify where the record was an INSERT, UPDATE OR DELETE? This would require editing the OPENQUERY Statement.

Any idea on the syntax...

Could you please add a delete to the example so that I have the syntax right?

I need to add the table name & Stored Procedure Name to the output.

The reason...

Thanks Mark.

What I need to capture is the total Number of records, Inserted, Updated & Deleted (count).

I do not care about the values inserted, updated or deleted.

I will also need...

Lynn Pettis (4/7/2012)

---

Trick question. If this is the data/time a record is inserted, why not leave it out of the MERGE entirely and set a default constraint value for...