Sorry I taught the next image was visible.

please see the data below. consider this as destination. Thanks..

CREATE TABLE [dbo].[testsolddest](

[Weeknumber] [int] NULL,

[customerphone] [char](12) NULL,

[Emailid] [varchar](100) NULL,

[customername] [varchar](50) NULL,

[vidsalesrep] [varchar](50) NULL,

[vidsatco] [char](20) NULL,

[numeric](1, 0) NULL,

[viddatesold] [datetime] NOT NULL,

[vidamtsold] [numeric](10, 2) NULL,

[vidcallorigination] [varchar](30) NULL,

[intsalesrep] [varchar](50) NULL,

[intsatco] [char](20) NULL,

[internet] [numeric](1, 0) NULL,

[intdatesold] [datetime] NOT NULL,

[intamtsold] [numeric](10, 2) NULL,

[intcallorigination] [varchar](30) NULL,

[basalesrep] [varchar](50) NULL,

[basatco] [char](20) NULL,

[ba] [numeric](1, 0) NULL,

[badatesold] [datetime] NOT NULL,

[baamtsold] [numeric](10, 2) NULL,

[bacallorigination] [varchar](30) NULL,

[ithgsalesrep] [varchar](50) NULL,

[ithgsatco] [char](20) NULL,

[ithg] [numeric](1, 0) NULL,

[ithgdatesold] [datetime] NOT NULL,

[ithgamtsold] [numeric](10, 2) NULL,

[ithgcallorigination] [varchar](30) NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

INSERT [dbo].[testsolddest] ([Weeknumber], [customerphone], [Emailid], [customername], [vidsalesrep], [vidsatco], , [viddatesold], [vidamtsold], [vidcallorigination], [intsalesrep], [intsatco], [internet], [intdatesold], [intamtsold], [intcallorigination], [basalesrep], [basatco], [ba], [badatesold], [baamtsold], [bacallorigination], [ithgsalesrep], [ithgsatco], [ithg], [ithgdatesold], [ithgamtsold], [ithgcallorigination]) VALUES (19, N'988 334-9999', N'MMM@gmail.com', N'Mon Joe', N'TRB', N'Dishtv', CAST(1 AS Numeric(1, 0)), CAST(0x0000A5FC00D6C98C AS DateTime), CAST(25.00 AS Numeric(10, 2)), N'6866', N' ', N' ', CAST(0 AS Numeric(1, 0)), CAST(0x0000000000000000 AS DateTime), CAST(0.00 AS Numeric(10, 2)), N'', N'TRB', N'BA', CAST(1 AS Numeric(1, 0)), CAST(0x0000A5FC00D753D4 AS DateTime), CAST(0.00 AS Numeric(10, 2)), N'6866', N'TRB', N'IT GROUP', CAST(1 AS Numeric(1, 0)), CAST(0x0000A5FC00D7229C AS DateTime), CAST(3.50 AS Numeric(10, 2)), N'6866')

INSERT [dbo].[testsolddest] ([Weeknumber], [customerphone], [Emailid], [customername], [vidsalesrep], [vidsatco], , [viddatesold], [vidamtsold], [vidcallorigination], [intsalesrep], [intsatco], [internet], [intdatesold], [intamtsold], [intcallorigination], [basalesrep], [basatco], [ba], [badatesold], [baamtsold], [bacallorigination], [ithgsalesrep], [ithgsatco], [ithg], [ithgdatesold], [ithgamtsold], [ithgcallorigination]) VALUES (19, N'888 333-3333', N'kalu@gmail.com', N'uhn anda', N'ROC', N'TWC', CAST(1 AS Numeric(1, 0)), CAST(0x0000A5FA00B54640 AS DateTime), CAST(25.00 AS Numeric(10, 2)), N' 999-312-4609', N'WAZ', N'CenturyLink', CAST(1 AS Numeric(1, 0)), CAST(0x0000A5F900AE6168 AS DateTime), CAST(80.00 AS Numeric(10, 2)), N' 999-312-4609', N' ', N' ', CAST(0 AS Numeric(1, 0)), CAST(0x0000000000000000 AS DateTime), CAST(0.00 AS Numeric(10, 2)), N'', N' ', N' ', CAST(1 AS Numeric(1, 0)), CAST(0x0000000000000000 AS DateTime), CAST(0.00 AS Numeric(10, 2)), N'')