1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| SELECT tFile.tNom + 'Xml' AS '@Name' , (
SELECT OptiCutingData.tNom AS '@Name'
, OptiCutingData.IdLot AS '@Run'
, (
SELECT BarData.[CompteurNo] AS '@BarNo'
, BarData.tRefSocSurDoc AS '@ProfileName'
,Bardata.tDescriptionRefSoc + BarData.tDescriptionRefSocComplement as '@Designation'
FROM [dbo].[Ma_View_Schem] AS BarData
WHERE BarData.IdLot = OptiCutingData.IdLot
AND Bardata.oType = 1
And Bardata.ptridcp = OptiCutingData.ptridcp
GROUP BY BarData.[CompteurNo]
, BarData.tRefSocSurDoc
,Bardata.tDescriptionRefSoc
,BarData.tDescriptionRefSocComplement
FOR XML path('BarData')
, type
)
FROM [dbo].[Ma_View_Schem] AS OptiCutingData
WHERE OptiCutingData.tNom = tFile.tNom
AND OptiCutingData.ptridcp = tFile.ptridcp
GROUP BY OptiCutingData.tNom
, OptiCutingData.IdLot
, OptiCutingData.ptridcp
FOR XML path('OptiCutingData')
, type
)
FROM [dbo].[Ma_View_Schem] AS tFile
WHERE tFile.IdLot = 5302
And tfile.[PtrIdCP] = 24
Order by lindice,[CompteurNo],sposition
FOR XML path('File') |
Partager