SHARE
TWEET

Untitled

a guest Jun 25th, 2019 55 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.         RootRecordId AS 'Route/@RootRecordId',
  3.         RouteNumber,
  4.         RouteName,
  5.         InternetName,
  6.         StartTime,
  7.         EndTime,
  8.         Direction AS 'RouteDirection/@Direction',
  9.         StopRecordId AS 'RouteStop/@StopRecordId',
  10.         Ord AS "Ordr"
  11.     FROM dbo.routes
  12.     FOR XML PATH (''), ROOT ('TMSFile');
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top