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