select c.name, c.colOrder from sysobjects t inner join syscolumns c on c.id = t.id where t.name = 'tbl_MFR_TPF_Detail' and t.xtype = 'u' order by c.colOrder select distinct m.mfr_id, m.mfr_name from tbl_MFR_TPF_Detail tpf inner join tblManufacturers m on m.mfr_id = tpf.mfr_id where not exists ( select * from sysobjects o where o.xtype = 'U' and o.name = 'tbl_MFR_TPF_Detail_MFR' + convert( varchar, m.mfr_id )) and m.mfr_id != 26 and exists( select * from tbl_MFR_TPF_Detail tpf2 with (nolock) where tpf2.mfr_id = tpf.mfr_id ) order by m.mfr_name truncate table tbl_MFR_TPF_Detail#_tableSuffix# insert into tbl_MFR_TPF_Detail#_tableSuffix# ( #_columns# ) select #_columns# from tbl_MFR_TPF_Detail with (nolock) where mfr_id =

MFR#_mfrId#: #lsnumberformat( _r.recordCount )# rows