สอบถามเกี่ยวกับการเขียนคำสั่ง Select ข้อมูลบน SQL server 2005

SELECT 
Status,
--Stuff 
  STUFF((
    SELECT ', ' + tmpPlant + '-' + CAST(tmpOrder AS VARCHAR(MAX)) 
    FROM #tmpEach 
    WHERE (tmpDateCollect = Results.tmpDateCollect) 
    FOR XML PATH(''),TYPE).value('(./text())[1]','VARCHAR(MAX)')
  ,1,2,'') AS [EACH ORDER]
FROM #tmpEach Results
GROUP BY tmpDateCollect,Status
order by tmpDateCollect