bpowers (4/3/2013)
I built a staging table and I am writing the last execution time of the sp to that table. How do I now use the execution time in the WHERE caluse of my sp, when the staging table has no logical join to the tables in my sp? Any help will be appreciated.
WHERE PURCHASE_ORDER.ADDED_DATE BETWEEN dbo.STOREDPROC.EXECUTED_TIME AND GETDATE()
Would need to know the structure of the table and the data stored, but I would see a select on the table returning a single value to be used in the WHERE clause.