create table #r
(
DateRecovery datetime
,TypeEvent int
,ObjectEvent nvarchar(50)
)

insert into #r(DateRecovery, TypeEvent, ObjectEvent)
select DateRecovery, TypeEvent, ObjectEvent
from
	(
	select getdate()-2 as DateRecovery, 3 as TypeEvent, 'day before yesterday' as ObjectEvent
union all
	select getdate()-1 as DateRecovery, 2 as TypeEvent, 'yesterday' as ObjectEvent
union all
	select getdate() as DateRecovery, 1 as TypeEvent, 'today' as ObjectEvent
	) as tb


select
	r.*
	,case when r.TypeEvent= 1 then 'аварийное отключение'
		  when r.TypeEvent= 2 then 'неотложное отключение'
		  when r.TypeEvent= 3 then 'плановое отключение'
		  else
			''
	 end as Type_Of_Shutdown

from #r r


drop table #r