CREATE TABLE [dbo].[tblLevelToLevelRel](

[GenLevelToLevelRelID] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[UpperLevelCloneID] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[LowerLevelCloneID] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[AllocPercent] [float] NOT NULL,

[Active] [bit] NULL,

[ChangedDate] [datetime] NULL,

[ChangedBy] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ChangedType] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ChangedMachineName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY]

the following query ran to update 153k records. I am having to do a database restore becaue of it.

Now when I look to run the following query, it wants to update 43k records. I haven't a clue why.

And I don't know if there is an answer to be honest.

begin tran

update tblleveltolevelrel set active = 0, changeddate = getdate(), changedmachinename = @@servername

FROM tblLevelToLevelRel INNER JOIN

TempDelete ON tblLevelToLevelRel.GenLevelToLevelRelID = TempDelete.genleveltolevelrelid

commit