Hi,
I have a stored procedure that is something like this
FOREACH
INSERT INTO ...
SELECT -----;
UPDATE ----
INSERT INTO ...
SELECT -----
....
END FOREACH
My question is do I need to set the SET PDQPRIORITY;
before each query in the SP or just applying it before the first query and all the following queries will implement it
Thanks
I have a stored procedure that is something like this
FOREACH
INSERT INTO ...
SELECT -----;
UPDATE ----
INSERT INTO ...
SELECT -----
....
END FOREACH
My question is do I need to set the SET PDQPRIORITY;
before each query in the SP or just applying it before the first query and all the following queries will implement it
Thanks