this is for table1 i,e t1

P1nvarchar(255)Checked

S1nvarchar(255)Checked

B1nvarchar(255)Checked

H1 -b1intChecked

H1 -s1intChecked

S2 -b1intChecked

S2 -s1intChecked

J1 -b1intChecked

J1 -s1intChecked

and this is for table 2 i,e t2

P1nvarchar(50)Checked

S1nvarchar(50)Checked

B1nvarchar(50)Checked

Funnvarchar(50)Checked

Valint Checked

Locnvarchar(50)Checked

and i have mentioned values and desired output in my previous file... plz check the txt document which is attached u willl get brief idea about it