could you add it to the previous query so i can get the correct result please? i dont know what else to put in the query. thanks

im sorry but im confused as to where to put what in the statement??

so what would be the syntax for that?

basically i have de-duped and flagged all duplicated as a duplicate, then i have linked them to its master record using the master records dqid. therefore all masters have thier...

data is attached, 2 spreadsheets in one file

/****** Object: Table [dbo].[Branch data 2009 - 2012] Script Date: 03/28/2012 09:22:56 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Branch data 2009 - 2012](

[DQID] [nvarchar](255) NULL,

[ID] [int]...

So i am looking for 1 Master record which only has 1 duplicate, and then 1 master with 2 dupes, i have already flagged the dupes and linked to the...

To be fair, it wasnt critical data and i could have rebuilt manually but would have taken alot longer than using that script.

Hi,

I found this from googleing my problem and it worked!

Create database with same name as MDF file you have.

Stop SQL Server and swap MDF files. Make sure you also keep...

but can you tell me why the from clause is the table i am updating? i thought it should be where the data is coming from i.e. DQMeta1

yes that was it, thanks very much

257,474 rows in target table, but i may have over looked; that because the criteria i was selecting on was duplicated maybe 4 times in the joining table that in...

so are you saying that the nearly 100k record count is not a true version of the data? it is replicating some of the records?

yes that is correct

yes i have and there are 75k that have not been updated