Originally Posted by
szlamany
Do you mean that you don't know where the "source table" is located" The table you are getting the data from?
Show me what you have in QA now - so we can build on it.
No, I mean the staging table.
Code:
declare @tmpSSStops "
Route_Num varchar(5), StopDate datetime, Stop_Num varchar(10),
Start_DateTime datetime, End_DateTime datetime, GPS_DateTime datetime, GPS_LAT numeric,
GPS_LONG numeric, GPS_ALT numeric, GPS_Speed numeric, GPS_Direction numeric,
Last_StopTime datetime, AreaID varchar(5), Begin_Cust_DT datetime, End_Cust_DT datetime
Reply With Quote