General information
Category:
Database DAO/RDO/ODBC/ADO
Hi Wilson:
You must use temporary tables instead permanent table. This has the advantage to use these tables while the transaction is running. Otherwise you have to drop the table before repeat the same query. Both solutions are:
Solution 1:
DROP TABLE TMP_PaytableFiltered
SELECT * INTO TMP_PaytableFiltered FROM Paytable
Solution 2:
SELECT * INTO #TMP_PaytableFiltered FROM Paytable
Each solution will work in function of your need.
Efrainn Contreras
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only