История страницы

-- в цоде
select
	so.Date as [DateBegin],
	so.DataEnd as [DateEnd],
	sm.ServiceMedicalCode as [Code],
	sm.ServiceMedicalName as [Name],
	op.Name as [TypeName],
	op.Code as [TypeCode]
from stt_MedicalHistory mh with(nolock)
join stt_SurgicalOperation so with(nolock) on so.rf_MedicalHistoryID = mh.MedicalHistoryID
left join oms_ServiceMedical sm with(nolock) on sm.ServiceMedicalID = so.rf_kl_ServiceMedicalID
left join stt_Operation op with(nolock) on op.OperationID = so.rf_OperationID
where mh.rf_mkabid in (select mkabid from hlt_mkab with(nolock) where UGUID IN(@0)) -- мкабы пациента