IF OBJECT_ID ('TB_SKLAD', 'V') IS NOT NULL
DROP VIEW TB_SKLAD;
GO
CREATE VIEW TB_SKLAD as 
select	Tb_Izd_Skl.CODE as IZD_CODE_S,
		Tb_Par_Skl.PARENTID as Par_Kod_S,
		Tb_Izd_Skl.ISFOLDER as IZD_FOLDER,
		Tb_Nom_Skl.CODE as Nom_Kod_S,
		Tb_Proba_Skl.SP380 as Pr_Koef_S,
		Tb_Post_Skl.CODE as Post_Kod_S,
		Tb_Razm_Skl.DESCR as Razm_Naim_S,
		Tb_Izd_Skl.SP626 as Ves_S,
		Tb_Izd_Skl.SP648 as Ves2_S,
		Tb_Izd_Skl.SP1284 as Cena_Vh_S
from линкованый_сервер.SC623 as Tb_Izd_Skl
		LEFT OUTER JOIN
			линкованый_сервер.SC12 as Tb_Nom_Skl on Tb_Izd_Skl.SP624 = Tb_Nom_Skl.ID
		LEFT OUTER JOIN
			линкованый_сервер.SC372 as Tb_Proba_Skl on Tb_Izd_Skl.SP1625 = Tb_Proba_Skl.ID
		LEFT OUTER JOIN
			линкованый_сервер.SC282 as Tb_Post_Skl on Tb_Izd_Skl.SP646 = Tb_Post_Skl.ID
		LEFT OUTER JOIN
			линкованый_сервер.SC14 as Tb_Razm_Skl on Tb_Izd_Skl.SP625 = Tb_Razm_Skl.ID
		LEFT OUTER JOIN
			линкованый_сервер.SC623 as Tb_Par_Skl on Tb_Izd_Skl.PARENTID = Tb_Par_Skl.ID

GO
IF OBJECT_ID ('TB_ROZN', 'V') IS NOT NULL
DROP VIEW TB_ROZN;
GO
CREATE VIEW TB_ROZN as  
select	Tb_Izd_Rozn.CODE as IZD_CODE_R,
		Tb_Par_Rozn.CODE as Par_Kod_R,
		Tb_Nom_Rozn.CODE as Nom_Kod_R,
		Tb_Post_Rozn.SP4976 as Post_Kod_R,
		Tb_Razm_Rozn.DESCR as Razm_Naim_R,
		Tb_Izd_Rozn.SP3524 as Ves_R,
		Tb_Izd_Rozn.SP3525 as Ves2_R,
		Tb_Izd_Rozn.SP4824 as Cena_Vh_R
from SC3521 as Tb_Izd_Rozn
		LEFT OUTER JOIN
			SC282 as Tb_Nom_Rozn on Tb_Izd_Rozn.SP3522 = Tb_Nom_Rozn.ID
		LEFT OUTER JOIN
			SC25 as Tb_Post_Rozn on Tb_Izd_Rozn.SP4160 = Tb_Post_Rozn.ID
		LEFT OUTER JOIN
			SC21 as Tb_Razm_Rozn on Tb_Izd_Rozn.SP3523 = Tb_Razm_Rozn.ID
		LEFT OUTER JOIN
			SC3521 as Tb_Par_Rozn on Tb_Izd_Rozn.PARENTID = Tb_Par_Rozn.ID

--new
GO
select top ( 100 ) TB_S_N.IZD_CODE_S,TB_S_N.IZD_FOLDER,TB_S_N.Par_Kod_S,TB_S_N.Nom_Kod_S,TB_S_N.Pr_Koef_S,TB_S_N.Post_Kod_S,TB_S_N.Razm_Naim_S,TB_S_N.Ves_S,TB_S_N.Ves2_S,TB_S_N.Cena_Vh_S
from TB_ROZN as TB_R_N
		RIGHT OUTER JOIN
			TB_SKLAD as TB_S_N on TB_S_N.IZD_CODE_S = TB_R_N.IZD_CODE_R
WHERE TB_R_N.IZD_CODE_R is NULL
ORDER BY TB_S_N.IZD_CODE_S