a guest Jun 25th, 2019 55 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- RootRecordId AS 'Route/@RootRecordId',
- Direction AS 'RouteDirection/@Direction',
- StopRecordId AS 'RouteStop/@StopRecordId',
- Ord AS "Ordr"
- FROM dbo.routes
- FOR XML PATH (''), ROOT ('TMSFile');
RAW Paste Data