Dear you can use below mentioned code for the same.

Using XML path function you can achieve this task.

-- Datas

DECLARE @jobs TABLE

(

street varchar(100),

seq int

);

insert @jobs VALUES ( 'A',1...

Will you provide semple script as Mentioned below and your Expected Output from the script.

Create Table #tableA

(

id int,

name varchar(100)

)

DROP TABLE #tableb

Create Table #tableb

(

id int,

f_id int,

ItemName varchar(100),

Date Datetime,

[Status] char(1)

)

Insert...

Will you provide your sample script with temp table or drieve table?. So it will hepfull to analyze yout problem.