SELECT INTO
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I am going through so old code adding in error checking and i came across this statement SQL = "SELECT RouteDef.RouteID, RouteDef.StepID, RouteDef.DeviceID, RouteDef.ReqPos INTO " + sTempTable + " FROM RouteDef WHERE (((RouteDef.RouteID)=" + IntToStr(iOldRouteNum) + "));"; The comment before the statement said something about creating a temporary table. My question is will this SELECT statement work on a SQL Server 200 machine? ----------------------- Ok now what? ----------------------- Never mind i found my answer. Thanks