Advertisement
Guest User

Untitled

a guest
May 29th, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 1.58 KB | None | 0 0
  1. use users
  2. go
  3.  
  4. --run tables/DeviceConfiguration.sql script
  5.  
  6. --move contents of mm905 table into DeviceConfiguration.
  7.  
  8. insert into dbo.DeviceConfiguration
  9. (
  10.     IPAddressNumber,
  11.     DestinationIPAddress,
  12.     DestinationPort,
  13.     ExceptionTiming,
  14.     StillTiming,
  15.     MovingTiming,
  16.     IgnitionHours,
  17.     StoppedTiming,
  18.     VoltageThreshold,
  19.     RSSIThreshold,
  20.     MinSpeed,
  21.     ColdTempProbe1,
  22.     HotTempProbe1,
  23.     ColdTempProbe2,
  24.     HotTempProbe2,
  25.     ReadTimeSwitch1,
  26.     ReadTimeSwitch2,
  27.     ReadTimeSwitch3,
  28.     ReadTimeSwitch4,
  29.     ReadTimeSwitch5,
  30.     ReadTimeSwitch6,
  31.     ReadTimeSwitch7,
  32.     ReadTimeSwitch8,
  33.     InputSwitchExceptions,
  34.     MiscIOExceptions,
  35.     Output1,
  36.     Output2,
  37.     Output3,
  38.     Output4,
  39.     SoftwareRev,
  40.     HardwareRev,
  41.     GPSFirmwareRev,
  42.     GPSType,
  43.     IButtonConfigOptions,
  44.     IButtonOutput1,
  45.     IButtonOutput2,
  46.     LastTimingUpdateDate,
  47.     LastTemperatureUpdateDate,
  48.     LastIOReadingUpdateDate,
  49.     LastRevisionUpdateDate
  50. )
  51. select
  52.     ipAddressNumber,
  53.     destIpAddress,
  54.     destPort,
  55.     exceptionTiming,
  56.     stillTiming,
  57.     movingTiming,
  58.     ignitionHours,
  59.     stoppedTiming,
  60.     voltageThreshold,
  61.     rssiThreshold,
  62.     minSpeed,
  63.     coldTempProbe1,
  64.     hotTempProbe1,
  65.     coldTempProbe2,
  66.     hotTempProbe2,
  67.     readTimeSw1,
  68.     readTimeSw2,
  69.     readTimeSw3,
  70.     readTimeSw4,
  71.     readTimeSw5,
  72.     readTimeSw6,
  73.     readTimeSw7,
  74.     readTimeSw8,
  75.     inputSwExceptions,
  76.     miscIOExceptions,
  77.     output1,
  78.     output2,
  79.     output3,
  80.     output4,
  81.     swRev,
  82.     hwRev,
  83.     gpsFirmwareRev
  84.     gpsType,
  85.     iButtonConfigOptions,
  86.     iButtonOutput1,
  87.     iButtonOutput2,
  88.     timingCmdUpdate,
  89.     temperatureCmdUpdate,
  90.     ioCmdUpdate,
  91.     revisionCmdUpdate
  92. from dbo.mm905
  93. where ipaddressnumber is not null
  94.  
  95. go
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement