Date: Thu, 28 Mar 2024 17:55:25 +0300 (MSK) Message-ID: <377751212.1161.1711637725511@jira> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_1160_1082675754.1711637725509" ------=_Part_1160_1082675754.1711637725509 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
=D0=9F=D0=BE=D0=BB=D1=83=D1=87=D0=B5=D0=BD=D0=B8=D0=B5 =D1=81=D0= =BF=D0=B8=D1=81=D0=BA=D0=B0 =D0=9B=D0=9F=D0=A3, =D0=B4=D0=BE=D1=81=D1=82=D1= =83=D0=BF=D0=BD=D1=8B=D1=85 =D0=B4=D0=BB=D1=8F =D0=B7=D0=B0=D0=BF=D0=B8=D1= =81=D0=B8 =D0=B4=D0=BB=D1=8F =D0=BE=D1=82=D0=BE=D0=B1=D1=80=D0=B0=D0=B6=D0= =B5=D0=BD=D0=B8=D1=8F =D0=BD=D0=B0 =D0=BF=D0=BE=D1=80=D1=82=D0=B0=D0=BB=D0= =B5 =D0=A0=D0=9F=D0=93=D0=A3 =D0=B8 =D0=B2 =D0=9A=D0=BE=D0=BB=D0=BB-=D0=A6= =D0=B5=D0=BD=D1=82=D1=80=D0=B5.
=D0=9F=D0=BE=D0=BB=D1=83=D1=87=D0=B5=D0=BD=D0=B8=D0=B5 =D1=8D=D1=82=D0= =BE=D0=B3=D0=BE =D1=81=D0=BF=D0=B8=D1=81=D0=BA=D0=B0 =D0=BF=D1=80=D0=BE=D0= =B8=D1=81=D1=85=D0=BE=D0=B4=D0=B8=D1=82 =D1=87=D0=B5=D1=80=D0=B5=D0=B7 =D0= =BC=D0=B5=D1=82=D0=BE=D0=B4 =D0=B8=D0=B7 =D0=B0=D0=BF=D0=B8 =D0=B4=D0=BB=D1= =8F =D1=80=D0=BF=D0=B3=D1=83 = 2.7. =D0=90=D0=B2=D1=82=D0=BE=D1=80=D0=B8=D0=B7=D0=B0=D1=86=D0=B8=D1=8F= (=D0=BE=D0=BF=D0=B8=D1=81=D0=B0=D1=82=D1=8C). =D0=AD=D1=82=D0=BE= =D1=82 =D0=BC=D0=B5=D1=82=D0=BE=D0=B4, =D0=B2 =D1=81=D0=B2=D0=BE=D1=8E =D0= =BE=D1=87=D0=B5=D1=80=D0=B5=D0=B4=D1=8C =D0=B8=D1=81=D0=BF=D0=BE=D0=BB=D1= =8C=D0=B7=D1=83=D0=B5=D1=82 =D0=BC=D0=B5=D1=82=D0=BE=D0=B4 =D0=9F=D0=BE=D0=BB=D1=83=D1=87=D0=B5=D0= =BD=D0=B8=D0=B5 =D0=B8=D0=BD=D1=84=D0=BE=D1=80=D0=BC=D0=B0=D1=86=D0=B8=D0= =B8 =D0=BE =D0=BF=D1=80=D0=B8=D0=BA=D1=80=D0=B5=D0=BF=D0=BB=D0=B5=D0=BD=D0= =B8=D1=8F=D1=85 =D0=BF=D0=B0=D1=86=D0=B8=D0=B5=D0=BD=D1=82=D0=B0=
=D0=A1=D0=BF=D0=B8=D1=81=D0=BE= =D0=BA =D0=BA=D0=B0=D1=80=D1=82 =D0=BF=D0=B0=D1=86=D0=B8=D0=B5=D0=BD=D1=82= =D0=B0 =D0=B2=D0=BC=D0=B5=D1=81=D1=82=D0=B5 =D1=81 =D0=B3=D1=83=D0=B8=D0=B4= =D0=B0=D0=BC=D0=B8 =D0=BB=D0=BF=D1=83(LpuMkab) =D0=BF=D0=BE=D0=BB=D1=83=D1= =87=D0=B0=D0=B5=D1=82=D1=81=D1=8F =D0=B8=D0=B7 =D0=9C=D0=98=D0=9F=D0=B0(cod= _person) g=D0=BF=D0=BE =D0=B8=D0=B4=D0=B5=D0=BD=D1=82=D0=B8=D1=84=D0=B8=D0= =BA=D0=B0=D1=82=D0=BE=D1=80=D1=83 =D0=BF=D0=B0=D1=86=D0=B8=D0=B5=D0=BD=D1= =82=D0=B0(PersonGuid) =D1=81 =D0=BF=D0=BE=D0=BC=D0=BE=D1=89=D1=8C=D1=8E =D0= =B7=D0=B0=D0=BF=D1=80=D0=BE=D1=81=D0=B0:
declare @@docmkab int =3D (select mn_DocLPUID from oms_mn_DocLPU wi= th(nolock) where Code =3D '1') select j.SourceGuid as [Mkab], lpu.GUIDLPU as [Lpu], per.BithDayDate as [BD], sex.CODE as [Gender], per.polis_number as [N_pol], per.polis_series as [S_pol], per.Surname as [Family], per.Name as [Name], per.Patronymic as [Patronymic], per.RegAddress_Str as [RegAddress], per.LiveAddress_Str as [LiveAddress], per.PhoneM as [Phone] from oms_mn_Journal j with (NOLOCK) join oms_LPU lpu with (NOLOCK) on lpu.LPUID =3D j.rf_LPUID join oms_mn_Person per with (nolock) on per.mn_PersonID =3D j.rf_mn_Person= ID join oms_kl_Sex sex with(nolock) on sex.kl_SexID =3D per.rf_kl_SexID where per.PersonGUID in (@0) -- =D0=B8=D0=B4=D0=B5=D0=BD=D1=82=D0=B8=D1=84= =D0=B8=D0=BA=D0=B0=D1=82=D0=BE=D1=80 =D0=BF=D0=B0=D1=86=D0=B8=D0=B5=D0=BD= =D1=82=D0=B0 and rf_mn_DocLPUID =3D @@docmkab and lpu.DATE_E > getdate()
=D0=9F=D0=BE=D1=81=D0=BB=D0=B5 =D0=BF=D0=BE=D0=BB=D1=83=D1=87=D0=B5=D0=
=BD=D0=B8=D1=8F =D0=B8=D0=B7 =D1=81=D0=BF=D0=B8=D1=81=D0=BA=D0=B0 =D1=83=D0=
=B1=D0=B8=D1=80=D0=B0=D1=8E=D1=82=D1=81=D1=8F =D0=B7=D0=B0=D0=BA=D1=80=D1=
=8B=D1=82=D1=8B=D0=B5 =D0=BA=D0=B0=D1=80=D1=82=D1=8B(=D0=BF=D1=80=D0=BE=D0=
=B2=D0=B5=D1=80=D0=BA=D0=B0 =D0=B2 =D1=82=D0=BE=D0=BC =D0=B6=D0=B5
select=20 UGUID as [MkabGuid], isClosed as [isClosed] from hlt_MKAB with(nolock) where uguid in (@0) --=D0=9D=D0=B0=D0=B9=D0=B4=D0=B5=D0=BD=D0=BD=D1=8B=D0= =B5 =D0=BA=D0=B0=D1=80=D1=82=D1=8B