<ZL_LIST><SCHET>
			<CODE>
			<CODE_MO>
			<YEAR>
			<MONTH>
			<NSCHET>
			<DSCHET>
			<SUMMAV>
			<COMENTS>
		</schet>
		<ZAP>
			<N_ZAP>
			<PR_NOV>
			<PACIENT>
				<ID_PAC>
				<VPOLIS>
				<NPOLIS>
				<ST_OKATO>
				<SMO>
				<SMO_OGRN>
				<SMO_OK>
				<SMO_NAM>
				<NOVOR>
			<Z_SL>
				<IDCASE>
				<USL_OK>
				<VIDPOM>
				<FOR_POM>
				<LPU>
				<DATE_Z_1>
				<DATE_Z_2>

				<SL>
					<SL_ID>

					<NHISTORY>
					<DATE_1>
					<DATE_2>

					<USL>
						<IDSERV>
						<LPU>
						<DATE_IN>
						<DATE_OUT>
						<DS>
						<CODE_USL>
						<KOL_USL>
						<CODE_MD>
					</usl>
					<COMENTSL>
				</sl>
				<IDSP>
				<SUMV>
			</z_sl>
		</zap>

SELECT 
col.x.query('DATE_IN').value('DATE_IN[1]','DATE') as DATE_IN,
col.x.query('DATE_OUT').value('DATE_OUT[1]','DATE') as DATE_OUT,
col.x.query('DS').value('DS[1]','VARCHAR(10)') as DS,
col.x.query('CODE_USL').value('CODE_USL[1]','VARCHAR(20)') as CODE_USL,

FROM prob A
CROSS APPLY A.Data.nodes('/ZL_LIST/ZAP/Z_SL/SL/USL') col(x)

SELECT 
col.x.value('DATE_IN[1]','DATE') as DATE_IN,
col.x.value('DATE_OUT[1]','DATE') as DATE_OUT,
...
col.x.value('../SL_ID[1]','int') as DATE_IN,
FROM prob A
CROSS APPLY A.Data.nodes('/ZL_LIST/ZAP/Z_SL/SL/USL') col(x)