create table #TableA

(

Col1 int,

Col2 char(10),

Col3 char(10),

Col4 char(10),

Col5 char(10)

)

create table #TableB

(

ColA int,

ColB char(10),

ColC char(10),

ColD char(10),

ColE char(10)

)

insert into #TableA Values (1,'a','abc','def','ghi')

insert into #TableA values (2, 'b','test','test','test')

insert into #TableA Values (3, 'c', 'test2','test2','test2')

insert...