I did the same thing but the issue is this only for student table, if we we have another table then we need to hardcode everything again for that new...

The result is same

Student IDNameClassGrade Last UpdatedStatus

1[p] Pratik12thA2013-06-04Updated

2 Jigar11th B2013-05-04Updated

3...

MERGE into linked.dbo.student tgt using linked.dbo.studentdetails src on src.[StudentID] = tgt.[ StudentID]

when matched then

update set tgt.[StudentID] = src.[StudentID],

tgt.[NAME] = src.[NAME],

tgt.[class] = src.[class],

tgt.[grade] = src.[grade],

tgt.[Last...

Pic: 1

Source table

Student IDNameClassGrade Last Updated

1 Pratik12thA2013-06-04

2 ...

Hi ,

This is the command I am using to run the SP.

EXEC@return_value = [dbo].[generate_merge1]

@SrcDB = LINKEDCP,

@SrcSchema = dbo,

@SrcTable = student,

@TgtDB = LINKEDCP,

@TgtSchema = dbo,

@TgtTable = totalstudent,

@predicate = StudentID,

@match_qual = NULL,

@not_match_qual...

Ya most of them I got solution..but struglling for the last one, but I found this forum pretty helpful..

The members like you , lowel and others..are really helping a lot...

Hi,

my code is as follows..it is also available on http://www.sqlservercentral.com/articles/EDW/77100/

CREATE PROCEDURE [student].[generate_merge]

...

Ok...I think I am very new to this forum..So if somthing has been done wrong, than it must be unintensionally.

I will now create a one topic and stick with...

yes your are right I have one coulmn that indicates timestamp, ineed to use that in order to perform incremental etl with destination table.

thanks.

yup..its totally empty..will automatically create after "Select * into from..." query...

Hi,

So my issue is..

I am copying the whole table with OPENQUERY from linked server(oracle) to sql server2008R2 in any temp. table A.

than I am copying just P.K. to another new...

Hi,

So my issue is..

I am copying the whole table with OPENQUERY from linked server(oracle) to sql server2008R2 in any temp. table A.

than I am copying just P.K. to another new...

Hi thanks a lot, for your quick replay ..

can you please provide me any related example if you have.?

thanks in advance.

can you please describe more..how can i achive this.?

thanks in advance.

I am using merge query, i need to indicate that the record is deleted WHEN NOT MATCHED BY THE SOURCE in merge query definition.

i have one column in my detination...