Insert into cnt_mst (site_cd,
					cnt_mst_module_cd,
					cnt_mst_prefix,
					cnt_mst_desc,
					cnt_mst_counter,
					cnt_mst_numbering,
					cnt_mst_option,
					audit_user,
					audit_date)
Select	site_cd, 'LDR', 'LDR', 'Linen Daily Routine Numbering', 100001, 'A', 'M', 'admin', getdate()
From	cf_site
UNION 
Select	site_cd, 'LRQ', 'LRQ', 'Linen Request Numbering', 100001, 'A', 'M', 'admin', getdate()
From	cf_site
UNION 
Select	site_cd, 'LRR', 'LRR', 'Linen Reject And Replace Numbering', 100001, 'A', 'M', 'admin', getdate()
From	cf_site
UNION 
Select	site_cd, 'LSF', 'LSF', 'Linen Satisfactory Form Numbering', 100001, 'A', 'M', 'admin', getdate()
From	cf_site
GO