i wish to create a task if there is any record from that SP, and then run
The SP return list of records.
My question is how to count records on SP?
i find this solution (http://www.sqldev.org/transactsql/how-to-return-count-from-same-stored-procedure-which-is-used-for-pagination-73308.shtml)
but my SQL is SQL2000 which does not support WITH clause.
Thans a lot.
View Complete Post