--В цоде
select top 1
case when mkab.RH = 0 then 1
when mkab.RH = 1 then 2
else 0 end as [RH], -- Если 0, то Undefined
gb.NAME as [BloodGroup] -- Если не получили, то Undefined
from hlt_mkab mkab with(nolock)
left join hlt_GroupOfBloodRH gb with(nolock) on mkab.rf_GroupOfBloodID = gb.GroupOfBloodRHID
where UGUID IN (@0) -- мкабы пациента
-- Получение RW и HIV
select
rt.Code as [Code],
rt.ResearchName,
res.Conclusion as [Result] -- Если нашли то пишем A12.06.011 в RW, а A26.06.048 в HIV
from lbr_research res with(nolock)
join lbr_ResearchType rt with(nolock) on rt.UGUID = res.rf_ResearchTypeUGUID
join lbr_LaboratoryResearch lr with(nolock) on lr.GUID = res.rf_LaboratoryResearchGUID
where rt.Code in ('A26.06.048', 'A12.06.011')
and lr.rf_MKABID in (select mkabid from hlt_mkab with(nolock) where UGUID IN(@0)) -- мкабы пациента
and res.isComplete = 1 |