SELECT IDENTITY(int) id0,* into #temp from [SysBI].[dbo].[SensorData]
select id0,
[DeviceID]
,[SensorTypeID]
,[SensorTypeIndex]
,[RecTime]
,[Data]
,[MastheadGUID]
FROM #temp where id0 > 1000 and id0 < 1101
select id0,
[DeviceID]
,[SensorTypeID]
,[SensorTypeIndex]
,[RecTime]
,[Data]
,[MastheadGUID]
FROM #temp where id0 > 1000 and id0 < 1101