Thanks!

I just wanted to assure you that we do have SQL server 2005 licenses and are in the process of migrating to 2005, but meanwhile we are trying to use...

Thanks Everyone! I have already made the change.

Thanks JacekO

I added

(Select Count(*) from Table)>0 in the where clause and it seemed to have worked

Let me clarify

If the count returns 0 -- I don't run the SP

If count>0 I run the sp

Table will always be there. SP runs when table has data. ...