Select * into EquipmentDataLog_backup from dbo.EquipmentDataLog
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
    -- Insert statements for procedure here
    WITH TempUsers (EquipmentId,EquipmentMasterParameterId,LogDateTime,duplicateRecordCount)
AS

(

SELECT EquipmentId,EquipmentMasterParameterId,LogDateTime,ROW_NUMBER()