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

-- в цоде
declare @@listOfIDs table (id int);
insert @@listOfIDs(id) select mkabid from hlt_mkab with(nolock) where UGUID IN(@0); -- мкабы пациента 
select
	mkb.name as [Name],
	mkb.DS as [Code]
from hlt_TAP t with(nolock)
join oms_kl_DiseaseType dt with(nolock) on t.rf_kl_DiseaseTypeID = dt.kl_DiseaseTypeID
join Oms_mkb mkb with(nolock) on t.rf_MKBID = mkb.mkbid
where t.rf_MKABID in (select id from @@listOfIDs)
and dt.code = '1'
and t.rf_MKBID != 0
union
select
	mkb.name as [Name],
	mkb.DS as [Code]
from  hlt_TAP t with(nolock)
join oms_kl_DiseaseType dt with(nolock) on t.rf_kl_DiseaseType2ID = dt.kl_DiseaseTypeID
join Oms_mkb mkb with(nolock) on t.rf_MKB2ID = mkb.mkbid
where t.rf_MKABID in (select id from @@listOfIDs)
and dt.code = '1'
and t.rf_MKB2ID != 0