use common select 'exec sp_detach_db "' + CompCode + '", "TRUE";' from Company_detail