Volume discounts - inserts from restored / backup DB

USE [HD Handel]
GO

SET IDENTITY_INSERT [dbo].[_etblVDAR] ON;
INSERT INTO [dbo].[_etblVDAR]
           ([IDVD],[iARAPID]
           ,[iGroupID]
           ,[iCurrencyID]
           ,[cContractName]
           ,[bOnHold]
           ,[tDescription]
           ,[bARAPAll]
           ,[bIsTemplate]
           ,[_etblVDAR_iBranchID]
           ,[_etblVDAR_dCreatedDate]
           ,[_etblVDAR_dModifiedDate]
           ,[_etblVDAR_iCreatedBranchID]
           ,[_etblVDAR_iModifiedBranchID]
           ,[_etblVDAR_iCreatedAgentID]
           ,[_etblVDAR_iModifiedAgentID]
           ,[_etblVDAR_iChangeSetID])
		   (
SELECT [IDVD]
      ,[iARAPID]
      ,[iGroupID]
      ,[iCurrencyID]
      ,[cContractName]
      ,[bOnHold]
      ,[tDescription]
      ,[bARAPAll]
      ,[bIsTemplate]
      ,[_etblVDAR_iBranchID]
      ,[_etblVDAR_dCreatedDate]
      ,[_etblVDAR_dModifiedDate]
      ,[_etblVDAR_iCreatedBranchID]
      ,[_etblVDAR_iModifiedBranchID]
      ,[_etblVDAR_iCreatedAgentID]
      ,[_etblVDAR_iModifiedAgentID]
      ,[_etblVDAR_iChangeSetID]
  FROM [HD Handel2].[dbo].[_etblVDAR] v1 where v1.IDVD not in (SELECT IDVD from [HD Handel].dbo._etblVDAR))

		   
SET IDENTITY_INSERT [dbo].[_etblVDAR] OFF;



GO


SET IDENTITY_INSERT [dbo].[_etblVDLnAR] ON;

INSERT INTO [HD Handel].[dbo].[_etblVDLnAR]
           ([IDVDLn]
		   ,[iVDID]
           ,[iStockID]
           ,[iStGroupID]
           ,[iCurrencyID]
           ,[dEffDate]
           ,[dExpDate]
           ,[bUseStockPrc]
           ,[cEnterInclExcl]
           ,[bIncremental]
           ,[bStockAll]
           ,[_etblVDLnAR_iBranchID]
           ,[_etblVDLnAR_dCreatedDate]
           ,[_etblVDLnAR_dModifiedDate]
           ,[_etblVDLnAR_iCreatedBranchID]
           ,[_etblVDLnAR_iModifiedBranchID]
           ,[_etblVDLnAR_iCreatedAgentID]
           ,[_etblVDLnAR_iModifiedAgentID]
           ,[_etblVDLnAR_iChangeSetID])
     (SELECT [IDVDLn],[iVDID]
           ,[iStockID]
           ,[iStGroupID]
           ,[iCurrencyID]
           ,[dEffDate]
           ,[dExpDate]
           ,[bUseStockPrc]
           ,[cEnterInclExcl]
           ,[bIncremental]
           ,[bStockAll]
           ,[_etblVDLnAR_iBranchID]
           ,[_etblVDLnAR_dCreatedDate]
           ,[_etblVDLnAR_dModifiedDate]
           ,[_etblVDLnAR_iCreatedBranchID]
           ,[_etblVDLnAR_iModifiedBranchID]
           ,[_etblVDLnAR_iCreatedAgentID]
           ,[_etblVDLnAR_iModifiedAgentID]
           ,[_etblVDLnAR_iChangeSetID] FROM [HD Handel2].dbo._etblVDLnAR v2 where v2.IDVDLn not in (SELECT IDVDLn from [HD Handel].dbo._etblVDLnAR))



SET IDENTITY_INSERT [dbo].[_etblVDLnAR] OFF;

GO



SET IDENTITY_INSERT [dbo].[_etblVDLnLvlAR] ON;


INSERT INTO [HD Handel].[dbo].[_etblVDLnLvlAR]
           (IDVDLnLvl
		   ,[iVDLnID]
           ,[iLevel]
           ,[fQuantity]
           ,[fPriceDisc]
           ,[_etblVDLnLvlAR_iBranchID]
           ,[_etblVDLnLvlAR_dCreatedDate]
           ,[_etblVDLnLvlAR_dModifiedDate]
           ,[_etblVDLnLvlAR_iCreatedBranchID]
           ,[_etblVDLnLvlAR_iModifiedBranchID]
           ,[_etblVDLnLvlAR_iCreatedAgentID]
           ,[_etblVDLnLvlAR_iModifiedAgentID]
           ,[_etblVDLnLvlAR_iChangeSetID])
     (SELECT IDVDLnLvl
		   ,[iVDLnID]
           ,[iLevel]
           ,[fQuantity]
           ,[fPriceDisc]
           ,[_etblVDLnLvlAR_iBranchID]
           ,[_etblVDLnLvlAR_dCreatedDate]
           ,[_etblVDLnLvlAR_dModifiedDate]
           ,[_etblVDLnLvlAR_iCreatedBranchID]
           ,[_etblVDLnLvlAR_iModifiedBranchID]
           ,[_etblVDLnLvlAR_iCreatedAgentID]
           ,[_etblVDLnLvlAR_iModifiedAgentID]
           ,[_etblVDLnLvlAR_iChangeSetID] FROM [HD Handel2].dbo._etblVDLnLvlAR v2 where v2.IDVDLnLvl not in (SELECT IDVDLnLvl from [HD Handel].dbo._etblVDLnLvlAR))
GO

SET IDENTITY_INSERT [dbo].[_etblVDLnLvlAR] OFF;

GO