CREATE TABLE [dbo].[tblSourceInUp](
	[ID] [int] NULL,
	[ValA] [varchar](255) NULL,
	[ValB] [varchar](255) NULL,
	[ValC] [varchar](255) NULL
CONSTRAINT [PK_tblSourceInUp] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[tblSourceMerge](
	[ID] [int] NULL,
	[ValA] [varchar](255) NULL,
	[ValB] [varchar](255) NULL,
	[ValC] [varchar](255) NULL
CONSTRAINT [PK_tblSourceMerge] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[tblTargetInUp](
	[ID] [int] NULL,
	[ValA] [varchar](255) NULL,
	[ValB] [varchar](255) NULL,
	[ValC] [varchar](255) NULL
CONSTRAINT [PK_tblTargetInUp] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[tblTargetMerge](
	[ID] [int] NULL,
	[ValA] [varchar](255) NULL,
	[ValB] [varchar](255) NULL,
	[ValC] [varchar](255) NULL
CONSTRAINT [PK_tblTargetMerge] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

DECLARE @i INT = 0

WHILE @i < 100000 BEGIN
	IF @i % 3 <> 0 BEGIN
		IF @i %2 = 0 BEGIN 
			--insert into tblsource
				INSERT INTO dbo.tblSourceMerge
				        ( ID, ValA, ValB, ValC )
				VALUES  ( @i, -- ID - int
				          REPLICATE('SourceMergeA', 2), -- ValA - varchar(255)
				          REPLICATE('SourceMergeB', 4), -- ValB - varchar(255)
				          REPLICATE('SourceMergeC', 3)  -- ValC - varchar(255)
				          )
				          
				INSERT INTO dbo.tblSourceInUp				        
				        ( ID, ValA, ValB, ValC )
				VALUES  ( @i, -- ID - int
				          REPLICATE('SourceMergeA', 2), -- ValA - varchar(255)
				          REPLICATE('SourceMergeB', 4), -- ValB - varchar(255)
				          REPLICATE('SourceMergeC', 3)  -- ValC - varchar(255)
				          )         
		END
		INSERT INTO dbo.TblTargetMerge
		        ( ID, ValA, ValB, ValC )
		VALUES  ( @i, -- ID - int
		          REPLICATE('TargetA', 7), -- ValA - varchar(255)
		          REPLICATE('TargetB', 3), -- ValB - varchar(255)
		          REPLICATE('TargetC', 4)  -- ValC - varchar(255)
		          )
		INSERT INTO dbo.TblTargetInUp
		        ( ID, ValA, ValB, ValC )
		VALUES  ( @i, -- ID - int
		          REPLICATE('TargetA', 7), -- ValA - varchar(255)
		          REPLICATE('TargetB', 3), -- ValB - varchar(255)
		          REPLICATE('TargetC', 4)  -- ValC - varchar(255)
		          )
		--insert into tbltarget
			
	END ELSE begin
		--insert into tblsource
		INSERT INTO dbo.TblSourceInUp
				        ( ID, ValA, ValB, ValC )
				VALUES  ( @i, -- ID - int
				          REPLICATE('SourceInsertA', 7), -- ValA - varchar(255)
				          REPLICATE('SourceInsertB', 4), -- ValB - varchar(255)
				          REPLICATE('SourceInsertC', 10)  -- ValC - varchar(255)
				          )
	
				INSERT INTO dbo.TblSourceMerge
				        ( ID, ValA, ValB, ValC )
				VALUES  ( @i, -- ID - int
				          REPLICATE('SourceInsertA', 7), -- ValA - varchar(255)
				          REPLICATE('SourceInsertB', 4), -- ValB - varchar(255)
				          REPLICATE('SourceInsertC', 10)  -- ValC - varchar(255)
				          )		          
	end
	SET @i += 1
END