select name as tableName from sysobjects where xtype = 'U' and name like 'tbl_MFR_TPF_Detail[_]MFR%' order by tableName select count(*) as tpfCount from #tableName# with (nolock)

#htmleditformat( tableName )# has #lsnumberformat( qmd_recordTest.tpfCount )# rows

select count(*) as tpfCount from tbl_MFR_TPF_Detail with (nolock) where abs( mfr_id ) =

tbl_MFR_TPF_Detail (mfr_Id = #_mfrId#) has #lsnumberformat( qmd_recordTest.tpfCount )# rows

delete from tbl_MFR_TPF_Detail where mfr_id =

Deleted #_r.recordCount# from #tableName#

delete from tbl_MFR_TPF_Detail where mfr_id =

Deleted #_r.recordCount# from #tableName# -#_mfrId#