Subversion Repositories computer_asset_manager_v1

/*
   changes an entire client to have maintenance performed
   by a specific technician
   change 
      login_id to technician
      client.name to client name
*/

update maintenance_schedule
   set login_id = 6
   where 
      removed_date is null
      and device_id in (
         select 
            distinct( device.device_id )
         from 
            device
            join device_type using (device_type_id)
            join site using (site_id)
            join client using (client_id)
         where
            client.name like '%primary%'
            and device_type.show_as_system = 'Y'
         );