select m.maint_id m.equipment_id e.equipment m.maint_program_id p.maint_program m.maint_schedule_id h.maint_schedule m.maint m.ok m.issue_number convert(varchar(25), m.dt_maint, 120) as dt_maint m.service_contract_id c.service_contract convert(varchar(25), c.dt_contract, 120) as dt_contract m.creator_id m.modifier_id convert(varchar(25), m.dt_created, 120) as dt_created convert(varchar(25), m.dt_modified, 120) as dt_modified m.descr m.contractor_id v.vendor as contractor convert(varchar(25), m.dt_appeared, 120) as dt_appeared m.engineer_id n.contact as engineer m.work_order_id w.work_order from maint m left outer join maint_schedule h on (m.maint_schedule_id=h.maint_schedule_id) left outer join equipment e on (isnull(m.equipment_id,h.equipment_id)=e.equipment_id) left outer join maint_program p on (isnull(m.maint_program_id,h.maint_program_id)=p.maint_program_id) left outer join contact n on (m.engineer_id=n.contact_id) left outer join service_contract c on (m.service_contract_id=c.service_contract_id) left outer join vendor v on (isnull(m.contractor_id,c.vendor_id)=v.vendor_id) left outer join work_order w on (m.work_order_id=w.work_order_id) where maint_id = update maint set ok= where maint_id = ; select @@rowcount as cnt;