Hi,
Thank you for reply.
In my trigger, it actually call another stored procedure to deduct stock qty. The code to deduct stock for all transactions are same, the only different that, it need to retrieve some field value from different header table. Therefore, I use dynamic SQL to do it.
Any other suggestions?
Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...