No announcements
Found 2012977 threads
-
0 VotesOLE DB Destination editor - Batch insert failure for duplicate records
This is one rare scenario where duplicates occur in the batch that is to inserted and the destination.Answered | 6 Replies | 3179 Views | Created by Saravana Kumar M R - Thursday, September 10, 2009 2:24 PM | Last reply by Phil Brammer - Thursday, September 10, 2009 2:51 PM
-
12 Votes
Record Count on MERGE Statement on Insert,Update,Delete
GROUP BY statement at the end around the merge sytax to directly set a variable to the OUTPUT $action field.Answered | 7 Replies | 62495 Views | Created by Khrizz_tell - Thursday, November 25, 2010 10:52 AM | Last reply by Karl Beran - Thursday, November 25, 2010 2:42 PM -
0 Votes
Merge statement insert and then delete
You want to physically move a unit record (punch card) from one deck to another!Answered | 2 Replies | 1007 Views | Created by anaylor01 - Thursday, July 24, 2014 1:55 AM | Last reply by --CELKO-- - Friday, July 25, 2014 12:55 AM -
0 Votes
Multitable Insert in one batch
I do not know how many parameters you have, but one potential solution would be to create stored procedure that accepts all the values as parameters and it will have multiple or single ...Answered | 3 Replies | 6531 Views | Created by Ringt - Thursday, March 18, 2010 5:44 AM | Last reply by Ringt - Sunday, March 21, 2010 8:09 AM -
2 Votes
MERGE statement throws Violation of PRIMARY KEY constraint ''.
Cannot insert duplicate key in object '' Previously calling this Merge statement for one row at a time, and I was getting result as ...Answered | 8 Replies | 15990 Views | Created by Rahul Techie - Sunday, March 18, 2012 7:34 AM | Last reply by Erland Sommarskog - Monday, March 19, 2012 8:52 AM -
0 Votes
avoid insertion of duplicate entries in a BULK INSERT statement
If your unique index has the ignore option on, then yes it will ignore the third record and insert the remainder.Answered | 4 Replies | 34987 Views | Created by Rahul_x_gupta - Wednesday, May 6, 2009 12:02 PM | Last reply by masher2 - Wednesday, May 6, 2009 12:29 PM -
2 Votes
insert records in batches..
Hi, I have a table with 20 millions of records. and I want then to insert into a different table.Answered | 6 Replies | 16613 Views | Created by K.Kalyan - Monday, July 26, 2010 2:45 PM | Last reply by KJian_ - Monday, August 2, 2010 9:57 AM -
0 Votes
Merge in batches - is it possible?
If you have to reduce the transaction size in order to improve performance, will batched MERGE outperform batched UPDATEs and INSERTs?Answered | 10 Replies | 9633 Views | Created by Naomi N - Friday, August 26, 2011 5:07 PM | Last reply by Kalman Toth - Monday, September 5, 2011 7:46 AM -
0 Votes
<MERGE> statement used in big tables
Article on SSIS MERGE usage: "There are many occasions where you will want to update a table in your data warehouse by adding new records and ...Answered | 4 Replies | 1584 Views | Created by fasttrack - Friday, February 22, 2013 4:24 PM | Last reply by Kalman Toth - Friday, February 22, 2013 4:57 PM -
0 Votes
Merge statement failed
The solution provided above fixed the MERGE statement error.Answered | 10 Replies | 1816 Views | Created by In-efficient - Thursday, September 17, 2015 1:35 PM | Last reply by In-efficient - Monday, September 21, 2015 5:30 PM -
0 Votes
Problem with MERGE Statement
> I wrote a MERGE statement with TARGET and SOURCE that either INSERTS a new record [sic] into a table if it doesn't already exist, and updates it if it ...Answered | 6 Replies | 3026 Views | Created by María89 - Friday, June 5, 2015 2:55 PM | Last reply by --CELKO-- - Sunday, June 24, 2018 4:29 PM -
1 Votes
Merge statement
Hi Meago, I belive it is not possible to do like that, instead you can get it done the same by spliting your MERGE statement into two different ...Answered | 4 Replies | 4146 Views | Created by Meago - Thursday, August 5, 2010 9:53 PM | Last reply by KiranKumar.Y - Friday, August 6, 2010 6:12 AM -
0 Votes
Check for Duplicate Record Before Inserting a New record
If it has key, you cannot add a duplicate row.Answered | 3 Replies | 993 Views | Created by Shayaan - Tuesday, July 8, 2014 3:45 PM | Last reply by --CELKO-- - Tuesday, July 8, 2014 8:20 PM -
0 Votes
Merge statement inside Merge
Based on particular record in the table I need to insert or update a different record in the same table.Answered | 5 Replies | 5510 Views | Created by Rishi Daftary - Friday, August 24, 2012 4:29 PM | Last reply by wBob - Tuesday, August 28, 2012 10:17 AM -
3 Votes
Best way to ignore duplicate inserts
INSERT If performance is an issue the problem is right there: "one record at a time".Answered | 9 Replies | 1865 Views | Created by David Zemdegs - Wednesday, November 27, 2019 8:31 PM | Last reply by David Zemdegs - Thursday, November 28, 2019 7:52 PM -
0 Votes
Merge Statement
You might want to review parts one, two, and five of the video series on this page - part five deals directly with your issue.Answered | 1 Replies | 5309 Views | Created by vineesh1 - Thursday, January 20, 2011 8:32 PM | Last reply by Todd McDermid - Friday, January 21, 2011 10:08 PM -
7 Votes
Preventing Duplicate inserts
So MDS has dup detection that can be enabled via the ImportType column in the staging table, but it only works for detecting dups in one column so to get around this ...Answered | 10 Replies | 4118 Views | Created by winstonSmith - Wednesday, March 4, 2015 5:27 PM | Last reply by reubster - Wednesday, November 25, 2015 6:35 AM -
1 Votes
What is wrong with this merge statement
You have: merge T2 as tgt When a batch in T-SQL starts with an identifier - and in SQL 2005 "merge" is ...Answered | 11 Replies | 13504 Views | Created by D00linDalton - Friday, June 3, 2011 9:08 PM | Last reply by Erland Sommarskog - Saturday, June 4, 2011 7:47 AM -
0 Votes
How to Delete duplicate record
In your case merge statement helps you lot.Answered | 6 Replies | 2490 Views | Created by Mak215 - Saturday, November 24, 2012 8:06 AM | Last reply by Uri Dimant - Sunday, November 25, 2012 8:17 AM -
0 Votes
Duplicate records issue?
If you give a size of say 10k, then any duplicate record in that particular batch of 10k rows would makes the whole batch to be treated as an error and ...Answered | 6 Replies | 4231 Views | Created by gk1393 - Wednesday, April 14, 2010 1:44 PM | Last reply by Nitesh Rai - Wednesday, April 14, 2010 3:40 PM - Items 1 to 20 of 2012977 Next ›
No announcements
