Welsh Corgi

Forum Replies Created

Viewing 15 posts - 1,516 through 1,530 (of 3,738 total)

RE: Need to Filter Query by Schema

R.P.Rozema (4/9/2012)
You seem to be in a real hurry for an answer, but maybe you should reread your question before becoming aggitated.
Who is agitated?:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 9, 2012 at 12:26 pm

#1470840
RE: OUTPUT CLAUSE replaced --when not matched by source then delete; WITH Update

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
...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 9, 2012 at 12:10 pm

#1470814
RE: OUTPUT CLAUSE replaced --when not matched by source then delete; WITH Update

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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 9, 2012 at 11:27 am

#1470776
RE: Need to Filter Query by Schema

Yeah, thanks for pointing that out.
What Table.Column should I JOIN ON?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 9, 2012 at 7:56 am

#1470662
RE: Merge OPEN QUERY - Need to Insert CurrentDateTime

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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 8, 2012 at 5:49 pm

#1470553
RE: OUTPUT CLAUSE - MERGE STATEMENT

Could I get a @@rowcount and have a column for DML Indicator, 'Insert or 'Update' and stored that information in the Table?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 8, 2012 at 5:46 pm

#1470552
RE: OUTPUT CLAUSE - MERGE STATEMENT

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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 8, 2012 at 3:09 pm

#1470543
RE: Staging Incremental Methodology - Flag Record as an INSERT, UPDATE or DELETE to the Data Warehouse Table

Carlos Bossy (4/7/2012)
#1 - Yes it is common practice to compare data in staging with the data warehouse.
Don't you perform the initial load to staging. Load the DW Tables, and...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 8, 2012 at 12:03 am

#1470498
RE: Staging Incremental Methodology - Flag Record as an INSERT, UPDATE or DELETE to the Data Warehouse Table

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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 8, 2012 at 12:01 am

#1470497
RE: Staging Incremental Methodology - Flag Record as an INSERT, UPDATE or DELETE to the Data Warehouse Table

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
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 7, 2012 at 11:22 pm

#1470494
RE: Merge OPEN QUERY - Need to Insert CurrentDateTime

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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 7, 2012 at 10:46 pm

#1470493
RE: OUTPUT CLAUSE - MERGE STATEMENT

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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 7, 2012 at 10:41 pm

#1470492
RE: OUTPUT CLAUSE - MERGE STATEMENT

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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 7, 2012 at 3:16 pm

#1470463
RE: OUTPUT CLAUSE - MERGE STATEMENT

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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 7, 2012 at 3:00 pm

#1470457
RE: Merge OPEN QUERY - Need to Insert CurrentDateTime

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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 7, 2012 at 2:38 pm

#1470453

Viewing 15 posts - 1,516 through 1,530 (of 3,738 total)