--...
FROM COM_ORG2 c
outer
apply (select top 1 VAL_STR from COM_ORG_AV where ATT = 'KO_BIC' and VNESHID = c.ID and DDB < getdate() order by DDB desc) b
outer
apply (select top 1 VAL_INT from COM_ORG_AV where ATT = 'FIZ_UR' and VNESHID = c.ID and DDB < getdate() order by DDB desc) t
outer
apply (select top 1 VAL_STR from COM_ORG_AV where ATT = 'FULLNAME' and VNESHID = c.ID and DDB < getdate() order by DDB desc) n
outer
apply (select top 1 VAL_STR from COM_ORG_AV where ATT = 'NAME_F_I' and VNESHID = c.ID and DDB < getdate() order by DDB desc) f
outer
apply (select top 1 VAL_STR from COM_ORG_AV where ATT = 'NAME_I_I' and VNESHID = c.ID and DDB < getdate() order by DDB desc) i
outer
apply (select top 1 VAL_STR from COM_ORG_AV where ATT = 'NAME_O_I' and VNESHID = c.ID and DDB < getdate() order by DDB desc) o
outer
apply (select top 1 VAL_INT from COM_ORG_AV where ATT = 'NERESIDENT' and VNESHID = c.ID and DDB < getdate() order by DDB desc) r
outer
apply (select top 1 VAL_STR from COM_ORG_AV where ATT = 'CODE_INN' and VNESHID = c.ID and DDB < getdate() order by DDB desc) ci
outer
apply (select top 1 VAL_STR from COM_ORG_AV where ATT = 'CODE_KPP' and VNESHID = c.ID and DDB < getdate() order by DDB desc) ck
outer
apply (select top 1 VAL_DATE from COM_ORG_AV where ATT = 'BIRTH_DAY' and VNESHID = c.ID and DDB < getdate() order by DDB desc) bd
outer
apply (select top 1 VAL_STR from COM_ORG_AV where ATT = 'BIRTH_PLACE' and VNESHID = c.ID and DDB < getdate() order by DDB desc) bp
outer
apply (select top 1 VAL_INT from COM_ORG_AV where ATT = 'POL' and VNESHID = c.ID and DDB < getdate() order by DDB desc) p
outer
apply (select top 1 VAL_STR from COM_ORG_AV where ATT = 'CODE_OGRN' and VNESHID = c.ID and DDB < getdate() order by DDB desc) og
outer
apply (select top 1 VAL_STR from COM_ORG_AV where ATT = 'CODE_OKFS' and VNESHID = c.ID and DDB < getdate() order by DDB desc) ok
outer
apply (select top 1 VAL_STR from COM_ORG_AV where ATT = 'CODE_OKPF' and VNESHID = c.ID and DDB < getdate() order by DDB desc) op
outer
apply (select top 1 VAL_STR from COM_ORG_AV where ATT = 'CODE_OKPO' and VNESHID = c.ID and DDB < getdate() order by DDB desc) oo
outer
apply (select top 1 VAL_STR from COM_ORG_AV where ATT = 'NAMEOF_FMS' and VNESHID = c.ID and DDB < getdate() order by DDB desc) fo
outer
apply (select top 1 VAL_STR from COM_ORG_AV where ATT = 'CODE_FSFR' and VNESHID = c.ID and DDB < getdate() order by DDB desc) fr
outer
apply (select top 1 VAL_STR from COM_ORG_AV where ATT = 'KOD_FSS' and VNESHID = c.ID and DDB < getdate() order by DDB desc) fs
outer
apply (select top 1 VAL_STR from COM_ORG_AV where ATT = 'REG_NOMER' and VNESHID = c.ID and DDB < getdate() order by DDB desc) rn
outer
apply (select top 1 VAL_STR from COM_ORG_AV where ATT = 'SNILS' and VNESHID = c.ID and DDB < getdate() order by DDB desc) s
outer
apply (select top 1 VAL_STR from COM_ORG_AV where ATT = 'GNI_NOMER' and VNESHID = c.ID and DDB < getdate() order by DDB desc) g
outer
apply (select top 1 VAL_STR from COM_ORG_AV where ATT = 'KO_BIC_SWIFT' and VNESHID = c.ID and DDB < getdate() order by DDB desc) ks