Hi all, this is the fist time to post here.
I have a problem and want to ask about and if there is a solution.
I built a stored procedure to do the following:
1- I have a physical indexed table A, and another physical table B
2- a built a dynamic SQL inside the stored procedure to read from table A some information and insert it to table B and do some update actions on table B, then get the result from table and delete the inserted records of table B.
the problem is, all actions go on the right way except for deleting from table B, in spite of deleting from table B without where condition. all rows of table B still exist.
I have a problem and want to ask about and if there is a solution.
I built a stored procedure to do the following:
1- I have a physical indexed table A, and another physical table B
2- a built a dynamic SQL inside the stored procedure to read from table A some information and insert it to table B and do some update actions on table B, then get the result from table and delete the inserted records of table B.
the problem is, all actions go on the right way except for deleting from table B, in spite of deleting from table B without where condition. all rows of table B still exist.