Here's the two scripts that I told earlier:

Code using temp. table:

CREATE TABLE #tmp_db_prop

(

dup_countINT

);

SET @v_dup_count_qry = 'SELECT COUNT(doc_id_pk) AS dup_count ...