case when ((otchet= 0 ) And (DateDiff hour,getdate,Pay_history.date_pay)> 120 )) then avrd=true else avrd=false

case when ((otchet= 0 ) And (DateDiff(hour,getdate,Pay_history.date_pay)> 120 )) then avrd=true else avrd=false

case when ((otchet= 0 ) And (DateDiff(hour,getdate(),Pay_history.date_pay)> 120 )) then  'true' else 'false' end as avrd, 

ALTER PROCEDURE dbo.ADV_report_otch
                      @id_pay int
AS
SET NOCOUNT ON
SELECT Base_plat.end_plat, Base_plat.Kurator, Base_plat.Nplat, Base_plat.Date_time, Base_plat.Who_pay, Base_plat.To_whom_pay, 
Base_plat.Document, Base_plat.Payment_form, Base_plat.Cost_center, Base_plat.Project, Base_plat.Phase, 
Base_plat.Account, Base_plat.Nomen, Base_plat.Sum, Base_plat.Currency, 
Base_plat.Prim, Base_plat.Declarant, Base_plat.Boss, Base_plat.Need_yes, Base_plat.Klass_corr_yes, Base_plat.Budget_yes, 
Base_plat.Doc_yes, Base_plat.Strategy_yes, Base_plat.Security_yes, Base_plat.OK, Plat.Plat, Etap.Etap, CFU.ЦФУ, CFO.CFO_name, 
Stati_sokr.Statya, Nomen.Nomenkl, Base_plat.Plat_vid, Base_plat.Otkl, Base_plat.Overdue, Base_plat.Kurr_OK, Base_plat.Opl_flag,
Base_plat.Opl_date, Base_plat.Ost_pay, Contract_main.N_contr, Nomenclator_job_and_st.Nom_code, Pay_history.Payed, 
Pay_history.Otchet, Pay_history.Vozvrat, Pay_history.RSCH_pay, OTVETSTVENNIE.Who_make_rep, Pay_history.Who_get, 
Pay_history.Nplat_CR, Pay_history.Date_pay,Pay_history.Npp, Pay_history.Sum_pay, Pay_history.Currency_pay, Base_plat.Contract_for_pay, Base_plat.Pay_type, 
Base_plat.Id_doc_contr, Base_plat.Type_doc_of_contr,case when ((otchet= 0 ) And (DateDiff(hour,getdate(),Pay_history.date_pay)> 120 )) then  'true' else 'false' end as avrd, 
ADV_Report.Id_pay, ADV_Report.Date_adv, ADV_Report.Type_N_doc_adv, 
ADV_Report.Describe_adv, ADV_Report.Sum_adv, ADV_Report.Curr_adv, ADV_Report.Date_time_add_adv, Stati_sokr.StatyaCod, 
ADV_Report.Curr_rate_adv, Base_plat.Budget_row
FROM (OTVETSTVENNIE RIGHT JOIN ((Nomenclator_job_and_st RIGHT JOIN (Contract_main RIGHT JOIN ((((Etap RIGHT JOIN
((Plat RIGHT JOIN Base_plat ON Plat.Pay_code = Base_plat.Who_pay) 
LEFT JOIN CFU ON Base_plat.Project = CFU.Новый_Код) ON Etap.Kod_et = Base_plat.Phase) 
LEFT JOIN CFO ON Base_plat.Cost_center = CFO.CFO_code) 
LEFT JOIN Nomen ON Base_plat.Nomen = Nomen.Npp) LEFT JOIN Stati_sokr ON Base_plat.Account = Stati_sokr.StatyaCod) 
ON Contract_main.ID_contr = Base_plat.Contract_for_pay) 
ON Nomenclator_job_and_st.Id_nom = Nomen.Nomenkl) RIGHT JOIN Pay_history ON Base_plat.Nplat = Pay_history.Nplat_CR) 
ON OTVETSTVENNIE.FIO = Pay_history.Who_get) RIGHT JOIN ADV_Report ON Pay_history.Npp = ADV_Report.Id_pay
WHERE ADV_Report.Id_pay=@Id_pay
order by base_plat.nplat
	RETURN