I need make out a xml output from a aggreagte function grouped with one more table

See more:

XML

SQL-Server

XSLT

aggregation

, +

I need to get an xml output where we have one lead no along with the resultset of aggregate function

Code snippet:

select distinct
ISNULL(job.joblead,'')
ROW_NUMBER() OVER(ORDER BY Desc) as Item_Number ,Count(*) Quantity,Desc Desc
FROM dbo.tableJob job
    left join jobprods  on thejob=tableJob
    left join ItemSkill on tblleadsprodsold_sp.theItem = ItemSkill.theItem
    left join SkillGroup on ItemSkill.theSkillGroup = SkillGroup.theKey
 where thejob = 6670683  and  tableJob=6670683
 group by SkillGroup.theKey, SkillGroup.Desc,tableJob
for xml path('Test')


Current output:
<Test>
  <joblead>6670683</joblead>
  <Item_Number>1</Item_Number>
  <Quantity>3</Quantity>
  <Desc>Inserts</Desc>
</Test>
<Test>
  <joblead>6670683</joblead>
  <Item_Number>2</Item_Number>
  <Quantity>1</Quantity>
  <Desc>Delte</Desc>
</Test>
<Test>
  <joblead>6670683</joblead>
  <Item_Number>3</Item_Number>
  <Quantity>1</Quantity>
  <Desc>Remove</Desc>
</Test>

Desired output:
<Test>
  <joblead>6670683</joblead>

  <Item_Number>1</Item_Number>
  <Quantity>3</Quantity>
  <Desc>Inserts</Desc>

  <Item_Number>2</Item_Number>
  <Quantity>1</Quantity>
  <Desc>Delte</Desc>

  <Item_Number>3</Item_Number>
  <Quantity>1</Quantity>
  <Desc>Remove</Desc>
</Test>