Hi there,

Thanks again for the respond. Herewith is my example of a simple syntax below which i tried to use but nothing gets appended.

Insert into tblModels (Column1,Column2,Column3,Column4,...)

Select Distinct Column1,Column2,Column3,Column4,....

From tblReceivedData

Where...

Hey, thank u for the respond.

Yes we usually append records into that table(tblModels) on a daily basis as we do receive more than 50 000 records and duplicates records are...

Hi There,

Yes i do agree that this question has been revolving round and round but i would like to get help as well. I used to work on MS SQL...

Hi, Thanks for the respond.

My situation here is different to what you've refered me to. Using SQL Server 2000, we used to have 1 central table that we all...