I recreate the stored procedure yesterday from my machine it works, the previous days my boss created the stored procedure from his machine it did not work.

The script I...

Thanks for your reply.

There is no error when I run the stored procedure. It returned empty result set. But if I run the sql in the stored procedure, it does...