USE [Курсач]
GO
/****** Object:  View [dbo].[зРаздел3_товары_импортные_1]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_импортные_1]
AS
SELECT        Название AS Показатели
FROM            dbo.тТовары_для_рекламы
WHERE        (Код_товара = 3) OR
                         (Код_товара = 4)
GROUP BY Название

GO
/****** Object:  View [dbo].[зРаздел3_товары_импортные_2]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_импортные_2]
AS
SELECT        dbo.зРаздел3_товары_импортные_1.Показатели, COUNT(dbo.тДоговоры.Код_договора) AS [Кол-во_договоров], SUM(dbo.тДоговоры.Сумма) AS Сумма
FROM            dbo.тТовары_для_рекламы INNER JOIN
                         dbo.тДоговоры ON dbo.тТовары_для_рекламы.Код_товара = dbo.тДоговоры.Код_товара INNER JOIN
                         dbo.зРаздел3_товары_импортные_1 ON dbo.тТовары_для_рекламы.Название = dbo.зРаздел3_товары_импортные_1.Показатели INNER JOIN
                         dbo.тПараметры ON YEAR(dbo.тДоговоры.Дата_договора) = dbo.тПараметры.Год
GROUP BY dbo.зРаздел3_товары_импортные_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_товары_импортные_3_общее]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_импортные_3_общее]
AS
SELECT        dbo.зРаздел3_товары_импортные_1.Показатели, ISNULL(dbo.зРаздел3_товары_импортные_2.[Кол-во_договоров], 0) AS [Кол-во_договоров], ISNULL(dbo.зРаздел3_товары_импортные_2.Сумма, 0)
                         AS Сумма
FROM            dbo.зРаздел3_товары_импортные_2 RIGHT OUTER JOIN
                         dbo.зРаздел3_товары_импортные_1 ON dbo.зРаздел3_товары_импортные_2.Показатели = dbo.зРаздел3_товары_импортные_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_товары_импортные_4]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_импортные_4]
AS
SELECT        dbo.зРаздел3_товары_импортные_1.Показатели, COUNT(dbo.тДоговоры.Код_договора) AS [Кол-во_договоров_полного_цикла_рекламных_услуг], SUM(dbo.тДоговоры.Сумма) AS Сумма
FROM            dbo.тТовары_для_рекламы INNER JOIN
                         dbo.тДоговоры ON dbo.тТовары_для_рекламы.Код_товара = dbo.тДоговоры.Код_товара INNER JOIN
                         dbo.зРаздел3_товары_импортные_1 ON dbo.тТовары_для_рекламы.Название = dbo.зРаздел3_товары_импортные_1.Показатели INNER JOIN
                         dbo.тПараметры ON YEAR(dbo.тДоговоры.Дата_договора) = dbo.тПараметры.Год
WHERE        (dbo.тДоговоры.Код_рекламной_услуги = 1)
GROUP BY dbo.зРаздел3_товары_импортные_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_товары_импортные_5_полный_цикл]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_импортные_5_полный_цикл]
AS
SELECT        dbo.зРаздел3_товары_импортные_1.Показатели, ISNULL(dbo.зРаздел3_товары_импортные_4.[Кол-во_договоров_полного_цикла_рекламных_услуг], 0)
                         AS [Кол-во_договоров_полного_цикла_рекламных_услуг], ISNULL(dbo.зРаздел3_товары_импортные_4.Сумма, 0) AS Сумма
FROM            dbo.зРаздел3_товары_импортные_4 RIGHT OUTER JOIN
                         dbo.зРаздел3_товары_импортные_1 ON dbo.зРаздел3_товары_импортные_4.Показатели = dbo.зРаздел3_товары_импортные_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_товары_импортные_6]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_импортные_6]
AS
SELECT        dbo.зРаздел3_товары_импортные_1.Показатели, COUNT(dbo.тДоговоры.Код_договора) AS [Кол-во_договоров_создания_и_распространения_рекламы], SUM(dbo.тДоговоры.Сумма) AS Сумма
FROM            dbo.тТовары_для_рекламы INNER JOIN
                         dbo.тДоговоры ON dbo.тТовары_для_рекламы.Код_товара = dbo.тДоговоры.Код_товара INNER JOIN
                         dbo.зРаздел3_товары_импортные_1 ON dbo.тТовары_для_рекламы.Название = dbo.зРаздел3_товары_импортные_1.Показатели INNER JOIN
                         dbo.тПараметры ON YEAR(dbo.тДоговоры.Дата_договора) = dbo.тПараметры.Год
WHERE        (dbo.тДоговоры.Код_рекламной_услуги = 2)
GROUP BY dbo.зРаздел3_товары_импортные_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_товары_импортные_7_создание]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_импортные_7_создание]
AS
SELECT        dbo.зРаздел3_товары_импортные_1.Показатели, ISNULL(dbo.зРаздел3_товары_импортные_6.[Кол-во_договоров_создания_и_распространения_рекламы], 0)
                         AS [Кол-во_договоров_создания_и_распространения_рекламы], ISNULL(dbo.зРаздел3_товары_импортные_6.Сумма, 0) AS Сумма
FROM            dbo.зРаздел3_товары_импортные_6 RIGHT OUTER JOIN
                         dbo.зРаздел3_товары_импортные_1 ON dbo.зРаздел3_товары_импортные_6.Показатели = dbo.зРаздел3_товары_импортные_6.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_товары_импортные_8]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_импортные_8]
AS
SELECT        dbo.зРаздел3_товары_импортные_1.Показатели, COUNT(dbo.тДоговоры.Код_договора) AS [Кол-во_договоров_размещение_распространение_рекламы], SUM(dbo.тДоговоры.Сумма) AS Сумма
FROM            dbo.тТовары_для_рекламы INNER JOIN
                         dbo.тДоговоры ON dbo.тТовары_для_рекламы.Код_товара = dbo.тДоговоры.Код_товара INNER JOIN
                         dbo.зРаздел3_товары_импортные_1 ON dbo.тТовары_для_рекламы.Название = dbo.зРаздел3_товары_импортные_1.Показатели INNER JOIN
                         dbo.тПараметры ON YEAR(dbo.тДоговоры.Дата_договора) = dbo.тПараметры.Год
WHERE        (dbo.тДоговоры.Код_рекламной_услуги = 3)
GROUP BY dbo.зРаздел3_товары_импортные_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_товары_импортные_9_размещение]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_импортные_9_размещение]
AS
SELECT        dbo.зРаздел3_товары_импортные_1.Показатели, ISNULL(dbo.зРаздел3_товары_импортные_8.[Кол-во_договоров_размещение_распространение_рекламы], 0)
                         AS [Кол-во_договоров_размещение_распространение_рекламы], ISNULL(dbo.зРаздел3_товары_импортные_8.Сумма, 0) AS Сумма
FROM            dbo.зРаздел3_товары_импортные_8 RIGHT OUTER JOIN
                         dbo.зРаздел3_товары_импортные_1 ON dbo.зРаздел3_товары_импортные_8.Показатели = dbo.зРаздел3_товары_импортные_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_товары_импортные_итог]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_импортные_итог]
AS
SELECT        dbo.зРаздел3_товары_импортные_3_общее.Показатели, dbo.зРаздел3_товары_импортные_3_общее.[Кол-во_договоров], dbo.зРаздел3_товары_импортные_3_общее.Сумма,
                         dbo.зРаздел3_товары_импортные_5_полный_цикл.[Кол-во_договоров_полного_цикла_рекламных_услуг], dbo.зРаздел3_товары_импортные_5_полный_цикл.Сумма AS Сумма_полный_цикл,
                         dbo.зРаздел3_товары_импортные_7_создание.[Кол-во_договоров_создания_и_распространения_рекламы] AS [Кол-во_договоров_планирования_и_создания_рекламы],
                         dbo.зРаздел3_товары_импортные_7_создание.Сумма AS Сумма_создание, dbo.зРаздел3_товары_импортные_9_размещение.[Кол-во_договоров_размещение_распространение_рекламы],
                         dbo.зРаздел3_товары_импортные_9_размещение.Сумма AS Сумма_размещение
FROM            dbo.зРаздел3_товары_импортные_3_общее INNER JOIN
                         dbo.зРаздел3_товары_импортные_5_полный_цикл ON dbo.зРаздел3_товары_импортные_3_общее.Показатели = dbo.зРаздел3_товары_импортные_5_полный_цикл.Показатели INNER JOIN
                         dbo.зРаздел3_товары_импортные_7_создание ON dbo.зРаздел3_товары_импортные_5_полный_цикл.Показатели = dbo.зРаздел3_товары_импортные_7_создание.Показатели INNER JOIN
                         dbo.зРаздел3_товары_импортные_9_размещение ON dbo.зРаздел3_товары_импортные_7_создание.Показатели = dbo.зРаздел3_товары_импортные_9_размещение.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_товары_импортные_всего]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_импортные_всего]
AS
SELECT        'Товары импортные' AS Показатели, SUM([Кол-во_договоров]) AS [Кол-во_договоров], SUM(Сумма) AS Сумма, SUM([Кол-во_договоров_полного_цикла_рекламных_услуг])
                         AS [Кол-во_договоров_полного_цикла_рекламных_услуг], SUM(Сумма_полный_цикл) AS Сумма_полный_цикл, SUM([Кол-во_договоров_планирования_и_создания_рекламы])
                         AS [Кол-во_договоров_планирования_и_создания_рекламы], SUM(Сумма_создание) AS Сумма_создание, SUM([Кол-во_договоров_размещение_распространение_рекламы])
                         AS [Кол-во_договоров_размещение_распространение_рекламы], SUM(Сумма_размещение) AS Сумма_размещение
FROM            dbo.зРаздел3_товары_импортные_итог

GO
/****** Object:  View [dbo].[зРаздел3__товары_импортные]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3__товары_импортные]
AS
SELECT        *
FROM            dbo.зРаздел3_товары_импортные_всего
UNION ALL
SELECT        *
FROM            dbo.зРаздел3_товары_импортные_итог

GO
/****** Object:  View [dbo].[зРаздел3_товар_технический_1]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товар_технический_1]
AS
SELECT        Название AS Показатели
FROM            dbo.тТовары_для_рекламы
WHERE        (Код_товара = 5)
GROUP BY Название

GO
/****** Object:  View [dbo].[зРаздел3_товар_технический_2_общее]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товар_технический_2_общее]
AS
SELECT        dbo.зРаздел3_товар_технический_1.Показатели, COUNT(dbo.тДоговоры.Код_договора) AS [Кол-во_договоров], SUM(ISNULL(dbo.тДоговоры.Сумма, 0)) AS Сумма
FROM            dbo.тТовары_для_рекламы INNER JOIN
                         dbo.тДоговоры ON dbo.тТовары_для_рекламы.Код_товара = dbo.тДоговоры.Код_товара INNER JOIN
                         dbo.тПараметры ON YEAR(dbo.тДоговоры.Дата_договора) = dbo.тПараметры.Год RIGHT OUTER JOIN
                         dbo.зРаздел3_товар_технический_1 ON dbo.тТовары_для_рекламы.Название = dbo.зРаздел3_товар_технический_1.Показатели
GROUP BY dbo.зРаздел3_товар_технический_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_товар_технический_3]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товар_технический_3]
AS
SELECT        dbo.зРаздел3_товар_технический_1.Показатели, COUNT(dbo.тДоговоры.Код_договора) AS [Кол-во_договоров], SUM(ISNULL(dbo.тДоговоры.Сумма, 0)) AS Сумма
FROM            dbo.тТовары_для_рекламы INNER JOIN
                         dbo.тДоговоры ON dbo.тТовары_для_рекламы.Код_товара = dbo.тДоговоры.Код_товара INNER JOIN
                         dbo.тПараметры ON YEAR(dbo.тДоговоры.Дата_договора) = dbo.тПараметры.Год RIGHT OUTER JOIN
                         dbo.зРаздел3_товар_технический_1 ON dbo.тТовары_для_рекламы.Название = dbo.зРаздел3_товар_технический_1.Показатели
WHERE        (dbo.тДоговоры.Код_рекламной_услуги = 1)
GROUP BY dbo.зРаздел3_товар_технический_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_товар_технический_4_полный_цикл]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товар_технический_4_полный_цикл]
AS
SELECT        dbo.зРаздел3_товар_технический_1.Показатели, ISNULL(dbo.зРаздел3_товар_технический_3.[Кол-во_договоров], 0) AS [Кол-во_договоров_полного_цикла_рекламных_услуг]]],
                         ISNULL(dbo.зРаздел3_товар_технический_3.Сумма, 0) AS Сумма_полный_цикл
FROM            dbo.зРаздел3_товар_технический_3 RIGHT OUTER JOIN
                         dbo.зРаздел3_товар_технический_1 ON dbo.зРаздел3_товар_технический_3.Показатели = dbo.зРаздел3_товар_технический_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_товар_технический_5]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товар_технический_5]
AS
SELECT        dbo.зРаздел3_товар_технический_1.Показатели, COUNT(dbo.тДоговоры.Код_договора) AS [Кол-во_договоров], SUM(ISNULL(dbo.тДоговоры.Сумма, 0)) AS Сумма
FROM            dbo.тТовары_для_рекламы INNER JOIN
                         dbo.тДоговоры ON dbo.тТовары_для_рекламы.Код_товара = dbo.тДоговоры.Код_товара INNER JOIN
                         dbo.тПараметры ON YEAR(dbo.тДоговоры.Дата_договора) = dbo.тПараметры.Год RIGHT OUTER JOIN
                         dbo.зРаздел3_товар_технический_1 ON dbo.тТовары_для_рекламы.Название = dbo.зРаздел3_товар_технический_1.Показатели
WHERE        (dbo.тДоговоры.Код_рекламной_услуги = 2)
GROUP BY dbo.зРаздел3_товар_технический_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_товар_технический_6_создание]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товар_технический_6_создание]
AS
SELECT        dbo.зРаздел3_товар_технический_1.Показатели, ISNULL(dbo.зРаздел3_товар_технический_5.[Кол-во_договоров], 0) AS [Кол-во_договоров_создания_и_распространения_рекламы],
                         ISNULL(dbo.зРаздел3_товар_технический_5.Сумма, 0) AS Сумма_создание
FROM            dbo.зРаздел3_товар_технический_5 RIGHT OUTER JOIN
                         dbo.зРаздел3_товар_технический_1 ON dbo.зРаздел3_товар_технический_5.Показатели = dbo.зРаздел3_товар_технический_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_товар_технический_7]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товар_технический_7]
AS
SELECT        dbo.зРаздел3_товар_технический_1.Показатели, COUNT(dbo.тДоговоры.Код_договора) AS [Кол-во_договоров], SUM(ISNULL(dbo.тДоговоры.Сумма, 0)) AS Сумма
FROM            dbo.тТовары_для_рекламы INNER JOIN
                         dbo.тДоговоры ON dbo.тТовары_для_рекламы.Код_товара = dbo.тДоговоры.Код_товара INNER JOIN
                         dbo.тПараметры ON YEAR(dbo.тДоговоры.Дата_договора) = dbo.тПараметры.Год RIGHT OUTER JOIN
                         dbo.зРаздел3_товар_технический_1 ON dbo.тТовары_для_рекламы.Название = dbo.зРаздел3_товар_технический_1.Показатели
WHERE        (dbo.тДоговоры.Код_рекламной_услуги = 3)
GROUP BY dbo.зРаздел3_товар_технический_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_товар_технический_8_размещение]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товар_технический_8_размещение]
AS
SELECT        dbo.зРаздел3_товар_технический_1.Показатели, ISNULL(dbo.зРаздел3_товар_технический_7.[Кол-во_договоров], 0) AS [Кол-во_договоров_размещение_распространение_рекламы],
                         ISNULL(dbo.зРаздел3_товар_технический_7.Сумма, 0) AS Сумма_размещение
FROM            dbo.зРаздел3_товар_технический_7 RIGHT OUTER JOIN
                         dbo.зРаздел3_товар_технический_1 ON dbo.зРаздел3_товар_технический_7.Показатели = dbo.зРаздел3_товар_технический_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3__товар_технический]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3__товар_технический]
AS
SELECT        dbo.зРаздел3_товар_технический_2_общее.Показатели, dbo.зРаздел3_товар_технический_2_общее.[Кол-во_договоров], dbo.зРаздел3_товар_технический_2_общее.Сумма,
                         dbo.зРаздел3_товар_технический_4_полный_цикл.[Кол-во_договоров_полного_цикла_рекламных_услуг]]], dbo.зРаздел3_товар_технический_4_полный_цикл.Сумма_полный_цикл,
                         dbo.зРаздел3_товар_технический_6_создание.[Кол-во_договоров_создания_и_распространения_рекламы] AS [Кол-во_договоров_планирования_и_создания_рекламы],
                         dbo.зРаздел3_товар_технический_6_создание.Сумма_создание, dbo.зРаздел3_товар_технический_8_размещение.[Кол-во_договоров_размещение_распространение_рекламы],
                         dbo.зРаздел3_товар_технический_8_размещение.Сумма_размещение
FROM            dbo.зРаздел3_товар_технический_2_общее INNER JOIN
                         dbo.зРаздел3_товар_технический_4_полный_цикл ON dbo.зРаздел3_товар_технический_2_общее.Показатели = dbo.зРаздел3_товар_технический_4_полный_цикл.Показатели INNER JOIN
                         dbo.зРаздел3_товар_технический_6_создание ON dbo.зРаздел3_товар_технический_4_полный_цикл.Показатели = dbo.зРаздел3_товар_технический_6_создание.Показатели INNER JOIN
                         dbo.зРаздел3_товар_технический_8_размещение ON dbo.зРаздел3_товар_технический_6_создание.Показатели = dbo.зРаздел3_товар_технический_8_размещение.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_услуги_1]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_услуги_1]
AS
SELECT        Название AS Показатели
FROM            dbo.тТовары_для_рекламы
WHERE        (Код_товара = 6) OR
                         (Код_товара = 7) OR
                         (Код_товара = 8) OR
                         (Код_товара = 9)
GROUP BY Название

GO
/****** Object:  View [dbo].[зРаздел3_услуги_2_общее]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_услуги_2_общее]
AS
SELECT        dbo.зРаздел3_услуги_1.Показатели, COUNT(dbo.тДоговоры.Код_договора) AS [Кол-во_договоров], SUM(ISNULL(dbo.тДоговоры.Сумма, 0)) AS Сумма
FROM            dbo.тТовары_для_рекламы INNER JOIN
                         dbo.тДоговоры ON dbo.тТовары_для_рекламы.Код_товара = dbo.тДоговоры.Код_товара INNER JOIN
                         dbo.тПараметры ON YEAR(dbo.тДоговоры.Дата_договора) = dbo.тПараметры.Год RIGHT OUTER JOIN
                         dbo.зРаздел3_услуги_1 ON dbo.тТовары_для_рекламы.Название = dbo.зРаздел3_услуги_1.Показатели
GROUP BY dbo.зРаздел3_услуги_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_услуги_3]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_услуги_3]
AS
SELECT        dbo.зРаздел3_услуги_1.Показатели, COUNT(dbo.тДоговоры.Код_договора) AS [Кол-во_договоров], SUM(ISNULL(dbo.тДоговоры.Сумма, 0)) AS Сумма
FROM            dbo.тТовары_для_рекламы INNER JOIN
                         dbo.тДоговоры ON dbo.тТовары_для_рекламы.Код_товара = dbo.тДоговоры.Код_товара INNER JOIN
                         dbo.тПараметры ON YEAR(dbo.тДоговоры.Дата_договора) = dbo.тПараметры.Год RIGHT OUTER JOIN
                         dbo.зРаздел3_услуги_1 ON dbo.тТовары_для_рекламы.Название = dbo.зРаздел3_услуги_1.Показатели
WHERE        (dbo.тДоговоры.Код_рекламной_услуги = 1)
GROUP BY dbo.зРаздел3_услуги_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_услуги_4_полный_цикл]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_услуги_4_полный_цикл]
AS
SELECT        dbo.зРаздел3_услуги_1.Показатели, ISNULL(dbo.зРаздел3_услуги_3.[Кол-во_договоров], 0) AS [Кол-во_договоров_полного_цикла_рекламных_услуг], ISNULL(dbo.зРаздел3_услуги_3.Сумма, 0)
                         AS Сумма_полный_цикл
FROM            dbo.зРаздел3_услуги_3 RIGHT OUTER JOIN
                         dbo.зРаздел3_услуги_1 ON dbo.зРаздел3_услуги_3.Показатели = dbo.зРаздел3_услуги_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_услуги_5]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_услуги_5]
AS
SELECT        dbo.зРаздел3_услуги_1.Показатели, COUNT(dbo.тДоговоры.Код_договора) AS [Кол-во_договоров], SUM(ISNULL(dbo.тДоговоры.Сумма, 0)) AS Сумма
FROM            dbo.тТовары_для_рекламы INNER JOIN
                         dbo.тДоговоры ON dbo.тТовары_для_рекламы.Код_товара = dbo.тДоговоры.Код_товара INNER JOIN
                         dbo.тПараметры ON YEAR(dbo.тДоговоры.Дата_договора) = dbo.тПараметры.Год RIGHT OUTER JOIN
                         dbo.зРаздел3_услуги_1 ON dbo.тТовары_для_рекламы.Название = dbo.зРаздел3_услуги_1.Показатели
WHERE        (dbo.тДоговоры.Код_рекламной_услуги = 2)
GROUP BY dbo.зРаздел3_услуги_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_услуги_6_создание]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_услуги_6_создание]
AS
SELECT        dbo.зРаздел3_услуги_1.Показатели, ISNULL(dbo.зРаздел3_услуги_5.[Кол-во_договоров], 0) AS [Кол-во_договоров_создания_и_распространения_рекламы], ISNULL(dbo.зРаздел3_услуги_5.Сумма, 0)
                         AS Сумма_создание
FROM            dbo.зРаздел3_услуги_5 RIGHT OUTER JOIN
                         dbo.зРаздел3_услуги_1 ON dbo.зРаздел3_услуги_5.Показатели = dbo.зРаздел3_услуги_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_услуги_7]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_услуги_7]
AS
SELECT        dbo.зРаздел3_услуги_1.Показатели, COUNT(dbo.тДоговоры.Код_договора) AS [Кол-во_договоров], SUM(ISNULL(dbo.тДоговоры.Сумма, 0)) AS Сумма
FROM            dbo.тТовары_для_рекламы INNER JOIN
                         dbo.тДоговоры ON dbo.тТовары_для_рекламы.Код_товара = dbo.тДоговоры.Код_товара INNER JOIN
                         dbo.тПараметры ON YEAR(dbo.тДоговоры.Дата_договора) = dbo.тПараметры.Год RIGHT OUTER JOIN
                         dbo.зРаздел3_услуги_1 ON dbo.тТовары_для_рекламы.Название = dbo.зРаздел3_услуги_1.Показатели
WHERE        (dbo.тДоговоры.Код_рекламной_услуги = 3)
GROUP BY dbo.зРаздел3_услуги_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_услуги_8_размещение]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_услуги_8_размещение]
AS
SELECT        dbo.зРаздел3_услуги_1.Показатели, ISNULL(dbo.зРаздел3_услуги_7.[Кол-во_договоров], 0) AS [Кол-во_договоров_размещение_распространение_рекламы], ISNULL(dbo.зРаздел3_услуги_7.Сумма, 0)
                         AS Сумма_размещение
FROM            dbo.зРаздел3_услуги_7 RIGHT OUTER JOIN
                         dbo.зРаздел3_услуги_1 ON dbo.зРаздел3_услуги_7.Показатели = dbo.зРаздел3_услуги_1.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_услуги_итог]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_услуги_итог]
AS
SELECT        dbo.зРаздел3_услуги_2_общее.Показатели, dbo.зРаздел3_услуги_2_общее.[Кол-во_договоров], dbo.зРаздел3_услуги_2_общее.Сумма,
                         dbo.зРаздел3_услуги_4_полный_цикл.[Кол-во_договоров_полного_цикла_рекламных_услуг], dbo.зРаздел3_услуги_4_полный_цикл.Сумма_полный_цикл,
                         dbo.зРаздел3_услуги_6_создание.[Кол-во_договоров_создания_и_распространения_рекламы] AS [Кол-во_договоров_планирования_и_создания_рекламы],
                         dbo.зРаздел3_услуги_6_создание.Сумма_создание, dbo.зРаздел3_услуги_8_размещение.[Кол-во_договоров_размещение_распространение_рекламы],
                         dbo.зРаздел3_услуги_8_размещение.Сумма_размещение
FROM            dbo.зРаздел3_услуги_2_общее INNER JOIN
                         dbo.зРаздел3_услуги_4_полный_цикл ON dbo.зРаздел3_услуги_2_общее.Показатели = dbo.зРаздел3_услуги_4_полный_цикл.Показатели INNER JOIN
                         dbo.зРаздел3_услуги_6_создание ON dbo.зРаздел3_услуги_4_полный_цикл.Показатели = dbo.зРаздел3_услуги_6_создание.Показатели INNER JOIN
                         dbo.зРаздел3_услуги_8_размещение ON dbo.зРаздел3_услуги_6_создание.Показатели = dbo.зРаздел3_услуги_8_размещение.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_услуги_всего]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_услуги_всего]
AS
SELECT        'Услуги' AS Показатели, SUM([Кол-во_договоров]) AS [Кол-во_договоров], SUM(Сумма) AS Сумма, SUM([Кол-во_договоров_полного_цикла_рекламных_услуг])
                         AS [Кол-во_договоров_полного_цикла_рекламных_услуг], SUM(Сумма_полный_цикл) AS Сумма_полный_цикл, SUM([Кол-во_договоров_планирования_и_создания_рекламы])
                         AS [Кол-во_договоров_планирования_и_создания_рекламы], SUM(Сумма_создание) AS Сумма_создание, SUM([Кол-во_договоров_размещение_распространение_рекламы])
                         AS [Кол-во_договоров_размещение_распространение_рекламы], SUM(Сумма_размещение) AS Сумма_размещение
FROM            dbo.зРаздел3_услуги_итог

GO
/****** Object:  View [dbo].[зРаздел3__услуги]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3__услуги]
AS
SELECT        *
FROM            dbo.зРаздел3_услуги_всего
UNION ALL
SELECT        *
FROM            dbo.зРаздел3_услуги_итог

GO
/****** Object:  View [dbo].[зРаздел3_товары_отечественные_1]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_отечественные_1]
AS
SELECT        Название
FROM            dbo.тТовары_для_рекламы
WHERE        (Код_товара = 1) OR
                         (Код_товара = 2)
GROUP BY Название

GO
/****** Object:  View [dbo].[зРаздел3_товары_отечественные_2]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_отечественные_2]
AS
SELECT        dbo.зРаздел3_товары_отечественные_1.Название AS Показатели, COUNT(dbo.тДоговоры.Код_договора) AS [Кол-во_договоров], SUM(dbo.тДоговоры.Сумма) AS Сумма
FROM            dbo.тТовары_для_рекламы INNER JOIN
                         dbo.тДоговоры ON dbo.тТовары_для_рекламы.Код_товара = dbo.тДоговоры.Код_товара INNER JOIN
                         dbo.зРаздел3_товары_отечественные_1 ON dbo.тТовары_для_рекламы.Название = dbo.зРаздел3_товары_отечественные_1.Название INNER JOIN
                         dbo.тПараметры ON YEAR(dbo.тДоговоры.Дата_договора) = dbo.тПараметры.Год
GROUP BY dbo.зРаздел3_товары_отечественные_1.Название

GO
/****** Object:  View [dbo].[зРаздел3_товары_отечественные_3_общее]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_отечественные_3_общее]
AS
SELECT        dbo.зРаздел3_товары_отечественные_1.Название AS Показатели, ISNULL(dbo.зРаздел3_товары_отечественные_2.[Кол-во_договоров], 0) AS [Кол-во_договоров],
                         ISNULL(dbo.зРаздел3_товары_отечественные_2.Сумма, 0) AS Сумма
FROM            dbo.зРаздел3_товары_отечественные_2 RIGHT OUTER JOIN
                         dbo.зРаздел3_товары_отечественные_1 ON dbo.зРаздел3_товары_отечественные_2.Показатели = dbo.зРаздел3_товары_отечественные_1.Название

GO
/****** Object:  View [dbo].[зРаздел3_товары_отечественные_4]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_отечественные_4]
AS
SELECT        dbo.зРаздел3_товары_отечественные_1.Название AS Показатели, COUNT(dbo.тДоговоры.Код_договора) AS [Кол-во_договоров_полного_цикла_рекламных_услуг], SUM(dbo.тДоговоры.Сумма)
                         AS Сумма
FROM            dbo.тТовары_для_рекламы INNER JOIN
                         dbo.тДоговоры ON dbo.тТовары_для_рекламы.Код_товара = dbo.тДоговоры.Код_товара INNER JOIN
                         dbo.зРаздел3_товары_отечественные_1 ON dbo.тТовары_для_рекламы.Название = dbo.зРаздел3_товары_отечественные_1.Название INNER JOIN
                         dbo.тПараметры ON YEAR(dbo.тДоговоры.Дата_договора) = dbo.тПараметры.Год
WHERE        (dbo.тДоговоры.Код_рекламной_услуги = 1)
GROUP BY dbo.зРаздел3_товары_отечественные_1.Название

GO
/****** Object:  View [dbo].[зРаздел3_товары_отечественные_5_полный_цикл]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_отечественные_5_полный_цикл]
AS
SELECT        dbo.зРаздел3_товары_отечественные_1.Название AS Показатели, ISNULL(dbo.зРаздел3_товары_отечественные_4.[Кол-во_договоров_полного_цикла_рекламных_услуг], 0)
                         AS [Кол-во_договоров_полного_цикла_рекламных_услуг], ISNULL(dbo.зРаздел3_товары_отечественные_4.Сумма, 0) AS Сумма
FROM            dbo.зРаздел3_товары_отечественные_4 RIGHT OUTER JOIN
                         dbo.зРаздел3_товары_отечественные_1 ON dbo.зРаздел3_товары_отечественные_4.Показатели = dbo.зРаздел3_товары_отечественные_1.Название

GO
/****** Object:  View [dbo].[зРаздел3_товары_отечественные_6]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_отечественные_6]
AS
SELECT        dbo.зРаздел3_товары_отечественные_1.Название AS Показатели, COUNT(dbo.тДоговоры.Код_договора) AS [Кол-во_договоров_создания_и_распространения_рекламы], SUM(dbo.тДоговоры.Сумма)
                         AS Сумма
FROM            dbo.тТовары_для_рекламы INNER JOIN
                         dbo.тДоговоры ON dbo.тТовары_для_рекламы.Код_товара = dbo.тДоговоры.Код_товара INNER JOIN
                         dbo.зРаздел3_товары_отечественные_1 ON dbo.тТовары_для_рекламы.Название = dbo.зРаздел3_товары_отечественные_1.Название INNER JOIN
                         dbo.тПараметры ON YEAR(dbo.тДоговоры.Дата_договора) = dbo.тПараметры.Год
WHERE        (dbo.тДоговоры.Код_рекламной_услуги = 2)
GROUP BY dbo.зРаздел3_товары_отечественные_1.Название

GO
/****** Object:  View [dbo].[зРаздел3_товары_отечественные_7_создание]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_отечественные_7_создание]
AS
SELECT        dbo.зРаздел3_товары_отечественные_1.Название AS Показатели, ISNULL(dbo.зРаздел3_товары_отечественные_6.[Кол-во_договоров_создания_и_распространения_рекламы], 0)
                         AS [Кол-во_договоров_создания_и_распространения_рекламы], ISNULL(dbo.зРаздел3_товары_отечественные_6.Сумма, 0) AS Сумма
FROM            dbo.зРаздел3_товары_отечественные_6 RIGHT OUTER JOIN
                         dbo.зРаздел3_товары_отечественные_1 ON dbo.зРаздел3_товары_отечественные_6.Показатели = dbo.зРаздел3_товары_отечественные_1.Название

GO
/****** Object:  View [dbo].[зРаздел3_товары_отечественные_8]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_отечественные_8]
AS
SELECT        dbo.зРаздел3_товары_отечественные_1.Название AS Показатели, COUNT(dbo.тДоговоры.Код_договора) AS [Кол-во_договоров_размещение_распространение_рекламы], SUM(dbo.тДоговоры.Сумма)
                         AS Сумма
FROM            dbo.тТовары_для_рекламы INNER JOIN
                         dbo.тДоговоры ON dbo.тТовары_для_рекламы.Код_товара = dbo.тДоговоры.Код_товара INNER JOIN
                         dbo.зРаздел3_товары_отечественные_1 ON dbo.тТовары_для_рекламы.Название = dbo.зРаздел3_товары_отечественные_1.Название INNER JOIN
                         dbo.тПараметры ON YEAR(dbo.тДоговоры.Дата_договора) = dbo.тПараметры.Год
WHERE        (dbo.тДоговоры.Код_рекламной_услуги = 3)
GROUP BY dbo.зРаздел3_товары_отечественные_1.Название

GO
/****** Object:  View [dbo].[зРаздел3_товары_отечественные_9_размещение]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_отечественные_9_размещение]
AS
SELECT        dbo.зРаздел3_товары_отечественные_1.Название AS Показатели, ISNULL(dbo.зРаздел3_товары_отечественные_8.[Кол-во_договоров_размещение_распространение_рекламы], 0)
                         AS [Кол-во_договоров_размещение_распространение_рекламы], ISNULL(dbo.зРаздел3_товары_отечественные_8.Сумма, 0) AS Сумма
FROM            dbo.зРаздел3_товары_отечественные_8 RIGHT OUTER JOIN
                         dbo.зРаздел3_товары_отечественные_1 ON dbo.зРаздел3_товары_отечественные_8.Показатели = dbo.зРаздел3_товары_отечественные_1.Название

GO
/****** Object:  View [dbo].[зРаздел3_товары_отечественные_итог]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_отечественные_итог]
AS
SELECT        dbo.зРаздел3_товары_отечественные_3_общее.Показатели, dbo.зРаздел3_товары_отечественные_3_общее.[Кол-во_договоров], dbo.зРаздел3_товары_отечественные_3_общее.Сумма,
                         dbo.зРаздел3_товары_отечественные_5_полный_цикл.[Кол-во_договоров_полного_цикла_рекламных_услуг], dbo.зРаздел3_товары_отечественные_5_полный_цикл.Сумма AS Сумма_полный_цикл,
                         dbo.зРаздел3_товары_отечественные_7_создание.[Кол-во_договоров_создания_и_распространения_рекламы] AS [Кол-во_договоров_планирования_и_создания_рекламы],
                         dbo.зРаздел3_товары_отечественные_7_создание.Сумма AS Сумма_создание, dbo.зРаздел3_товары_отечественные_9_размещение.[Кол-во_договоров_размещение_распространение_рекламы],
                         dbo.зРаздел3_товары_отечественные_9_размещение.Сумма AS Сумма_размещение
FROM            dbo.зРаздел3_товары_отечественные_3_общее INNER JOIN
                         dbo.зРаздел3_товары_отечественные_5_полный_цикл ON dbo.зРаздел3_товары_отечественные_3_общее.Показатели = dbo.зРаздел3_товары_отечественные_5_полный_цикл.Показатели INNER JOIN
                         dbo.зРаздел3_товары_отечественные_7_создание ON dbo.зРаздел3_товары_отечественные_5_полный_цикл.Показатели = dbo.зРаздел3_товары_отечественные_7_создание.Показатели INNER JOIN
                         dbo.зРаздел3_товары_отечественные_9_размещение ON dbo.зРаздел3_товары_отечественные_7_создание.Показатели = dbo.зРаздел3_товары_отечественные_9_размещение.Показатели

GO
/****** Object:  View [dbo].[зРаздел3_товары_отечественные_всего]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3_товары_отечественные_всего]
AS
SELECT        'Товары отечественные' AS Показатели, SUM([Кол-во_договоров]) AS [Кол-во_договоров], SUM(Сумма) AS Сумма, SUM([Кол-во_договоров_полного_цикла_рекламных_услуг])
                         AS [Кол-во_договоров_полного_цикла_рекламных_услуг], SUM(Сумма_полный_цикл) AS Сумма_полный_цикл, SUM([Кол-во_договоров_планирования_и_создания_рекламы])
                         AS [Кол-во_договоров_планирования_и_создания_рекламы], SUM(Сумма_создание) AS Сумма_создание, SUM([Кол-во_договоров_размещение_распространение_рекламы])
                         AS [Кол-во_договоров_размещение_распространение_рекламы], SUM(Сумма_размещение) AS Сумма_размещение
FROM            dbo.зРаздел3_товары_отечественные_итог

GO
/****** Object:  View [dbo].[зРаздел3__всего]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3__всего]
AS
SELECT        'Итог по всем договорам' AS Показатели, SUM([Кол-во_договоров]) AS [Кол-во_договоров], SUM(Сумма) AS Сумма, SUM([Кол-во_договоров_полного_цикла_рекламных_услуг])
                         AS [Кол-во_договоров_полного_цикла_рекламных_услуг], SUM(Сумма_полный_цикл) AS Сумма_полный_цикл, SUM([Кол-во_договоров_планирования_и_создания_рекламы])
                         AS [Кол-во_договоров_планирования_и_создания_рекламы], SUM(Сумма_создание) AS Сумма_создание, SUM([Кол-во_договоров_размещение_распространение_рекламы])
                         AS [Кол-во_договоров_размещение_распространение_рекламы], SUM(Сумма_размещение) AS Сумма_размещение
FROM            (SELECT        Показатели, [Кол-во_договоров], Сумма, [Кол-во_договоров_полного_цикла_рекламных_услуг], Сумма_полный_цикл, [Кол-во_договоров_планирования_и_создания_рекламы],
                                                    Сумма_создание, [Кол-во_договоров_размещение_распространение_рекламы], Сумма_размещение
                          FROM            dbo.зРаздел3_товары_отечественные_всего
                          UNION ALL
                          SELECT        Показатели, [Кол-во_договоров], Сумма, [Кол-во_договоров_полного_цикла_рекламных_услуг], Сумма_полный_цикл, [Кол-во_договоров_планирования_и_создания_рекламы],
                                                   Сумма_создание, [Кол-во_договоров_размещение_распространение_рекламы], Сумма_размещение
                          FROM            dbo.зРаздел3_товары_импортные_всего
                          UNION ALL
                          SELECT        Показатели, [Кол-во_договоров], Сумма, [Кол-во_договоров_полного_цикла_рекламных_услуг]]], Сумма_полный_цикл, [Кол-во_договоров_планирования_и_создания_рекламы],
                                                   Сумма_создание, [Кол-во_договоров_размещение_распространение_рекламы], Сумма_размещение
                          FROM            dbo.зРаздел3__товар_технический
                          UNION ALL
                          SELECT        Показатели, [Кол-во_договоров], Сумма, [Кол-во_договоров_полного_цикла_рекламных_услуг], Сумма_полный_цикл, [Кол-во_договоров_планирования_и_создания_рекламы],
                                                   Сумма_создание, [Кол-во_договоров_размещение_распространение_рекламы], Сумма_размещение
                          FROM            dbo.зРаздел3_услуги_всего) AS derivedtbl_1

GO
/****** Object:  View [dbo].[зРаздел3__товары_отечественные]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3__товары_отечественные]
AS
SELECT  *
FROM            dbo.зРаздел3_товары_отечественные_всего
UNION ALL
SELECT * FROM dbo.зРаздел3_товары_отечественные_итог

GO
/****** Object:  View [dbo].[зРаздел3]    Script Date: 04.02.2016 1:58:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[зРаздел3]
AS
SELECT * FROM dbo.зРаздел3__всего UNION ALL
SELECT * FROM dbo.зРаздел3__товары_отечественные UNION ALL

SELECT * FROM                          dbo.зРаздел3__товары_импортные UNION ALL

SELECT * FROM                          dbo.зРаздел3__товар_технический UNION ALL

SELECT * FROM                          dbo.зРаздел3__услуги

GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3__товары_отечественные"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 136
               Right = 461
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3__товары_импортные"
            Begin Extent =
               Top = 6
               Left = 499
               Bottom = 136
               Right = 922
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3__товар_технический"
            Begin Extent =
               Top = 138
               Left = 38
               Bottom = 268
               Right = 461
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3__услуги"
            Begin Extent =
               Top = 138
               Left = 499
               Bottom = 268
               Right = 922
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3__всего"
            Begin Extent =
               Top = 270
               Left = 38
               Bottom = 400
               Right = 461
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 3855
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      B' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @VALUE=N'egin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "derivedtbl_1"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 136
               Right = 461
            End
            DisplayFlags = 280
            TopColumn = 5
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 10
         Width = 284
         Width = 2400
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 3555
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3__всего'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3__всего'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_товар_технический_2_общее"
            Begin Extent =
               Top = 21
               Left = 27
               Bottom = 134
               Right = 219
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товар_технический_4_полный_цикл"
            Begin Extent =
               Top = 6
               Left = 267
               Bottom = 119
               Right = 654
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товар_технический_6_создание"
            Begin Extent =
               Top = 5
               Left = 770
               Bottom = 118
               Right = 1185
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товар_технический_8_размещение"
            Begin Extent =
               Top = 212
               Left = 341
               Bottom = 325
               Right = 764
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 10
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 4350
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 6015
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
  ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3__товар_технический'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @VALUE=N'       SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3__товар_технический'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3__товар_технический'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 3195
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3__товары_импортные'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3__товары_импортные'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_товары_отечественные_всего"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 136
               Right = 461
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_отечественные_итог"
            Begin Extent =
               Top = 6
               Left = 499
               Bottom = 136
               Right = 922
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 3525
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3__товары_отечественные'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3__товары_отечественные'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3__услуги'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3__услуги'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "тТовары_для_рекламы"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 102
               Right = 208
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 4020
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товар_технический_1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товар_технический_1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "тТовары_для_рекламы"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 102
               Right = 224
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тДоговоры"
            Begin Extent =
               Top = 6
               Left = 262
               Bottom = 136
               Right = 496
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тПараметры"
            Begin Extent =
               Top = 6
               Left = 758
               Bottom = 85
               Right = 944
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товар_технический_1"
            Begin Extent =
               Top = 6
               Left = 534
               Bottom = 85
               Right = 720
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1785
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товар_технический_2_общее'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @VALUE=N'         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товар_технический_2_общее'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товар_технический_2_общее'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "тТовары_для_рекламы"
            Begin Extent =
               Top = 202
               Left = 700
               Bottom = 298
               Right = 886
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тДоговоры"
            Begin Extent =
               Top = 6
               Left = 262
               Bottom = 136
               Right = 496
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тПараметры"
            Begin Extent =
               Top = 6
               Left = 534
               Bottom = 85
               Right = 720
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товар_технический_1"
            Begin Extent =
               Top = 199
               Left = 177
               Bottom = 278
               Right = 363
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 2355
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or =' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товар_технический_3'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @VALUE=N' 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товар_технический_3'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товар_технический_3'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_товар_технический_3"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 119
               Right = 229
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товар_технический_1"
            Begin Extent =
               Top = 6
               Left = 267
               Bottom = 85
               Right = 437
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 2820
         Alias = 2400
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товар_технический_4_полный_цикл'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товар_технический_4_полный_цикл'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "тТовары_для_рекламы"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 102
               Right = 224
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тДоговоры"
            Begin Extent =
               Top = 6
               Left = 262
               Bottom = 136
               Right = 496
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тПараметры"
            Begin Extent =
               Top = 6
               Left = 534
               Bottom = 85
               Right = 720
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товар_технический_1"
            Begin Extent =
               Top = 6
               Left = 758
               Bottom = 85
               Right = 944
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товар_технический_5'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @VALUE=N'         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товар_технический_5'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товар_технический_5'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_товар_технический_1"
            Begin Extent =
               Top = 6
               Left = 267
               Bottom = 85
               Right = 437
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товар_технический_5"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 119
               Right = 229
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 6225
         Alias = 2715
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товар_технический_6_создание'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товар_технический_6_создание'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "тТовары_для_рекламы"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 102
               Right = 224
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тДоговоры"
            Begin Extent =
               Top = 6
               Left = 262
               Bottom = 136
               Right = 496
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тПараметры"
            Begin Extent =
               Top = 6
               Left = 534
               Bottom = 85
               Right = 720
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товар_технический_1"
            Begin Extent =
               Top = 6
               Left = 758
               Bottom = 85
               Right = 944
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товар_технический_7'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товар_технический_7'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_товар_технический_7"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 119
               Right = 229
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товар_технический_1"
            Begin Extent =
               Top = 6
               Left = 267
               Bottom = 85
               Right = 437
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 2970
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товар_технический_8_размещение'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товар_технический_8_размещение'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "тТовары_для_рекламы"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 102
               Right = 208
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 3585
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "тТовары_для_рекламы"
            Begin Extent =
               Top = 155
               Left = 425
               Bottom = 251
               Right = 611
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тДоговоры"
            Begin Extent =
               Top = 88
               Left = 74
               Bottom = 218
               Right = 308
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тПараметры"
            Begin Extent =
               Top = 6
               Left = 410
               Bottom = 85
               Right = 596
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_импортные_1"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 85
               Right = 224
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 2400
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 4365
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @VALUE=N'
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_товары_импортные_2"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 119
               Right = 229
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_импортные_1"
            Begin Extent =
               Top = 6
               Left = 267
               Bottom = 85
               Right = 437
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 2865
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 2790
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_3_общее'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_3_общее'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "тТовары_для_рекламы"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 102
               Right = 224
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тДоговоры"
            Begin Extent =
               Top = 6
               Left = 262
               Bottom = 136
               Right = 496
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_импортные_1"
            Begin Extent =
               Top = 6
               Left = 534
               Bottom = 85
               Right = 720
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тПараметры"
            Begin Extent =
               Top = 6
               Left = 758
               Bottom = 85
               Right = 944
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
 ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_4'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @VALUE=N'        Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_4'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_4'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_товары_импортные_4"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 119
               Right = 421
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_импортные_1"
            Begin Extent =
               Top = 6
               Left = 459
               Bottom = 85
               Right = 629
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_5_полный_цикл'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_5_полный_цикл'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "тТовары_для_рекламы"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 102
               Right = 224
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тДоговоры"
            Begin Extent =
               Top = 6
               Left = 262
               Bottom = 136
               Right = 496
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_импортные_1"
            Begin Extent =
               Top = 6
               Left = 534
               Bottom = 85
               Right = 720
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тПараметры"
            Begin Extent =
               Top = 6
               Left = 758
               Bottom = 85
               Right = 944
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 4605
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_6'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @VALUE=N'         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_6'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_6'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_товары_импортные_1"
            Begin Extent =
               Top = 46
               Left = 578
               Bottom = 125
               Right = 748
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_импортные_6"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 119
               Right = 453
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_7_создание'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_7_создание'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "тТовары_для_рекламы"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 102
               Right = 224
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тДоговоры"
            Begin Extent =
               Top = 6
               Left = 262
               Bottom = 136
               Right = 496
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_импортные_1"
            Begin Extent =
               Top = 6
               Left = 534
               Bottom = 85
               Right = 720
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тПараметры"
            Begin Extent =
               Top = 6
               Left = 758
               Bottom = 85
               Right = 944
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 3165
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_8'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @VALUE=N'         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_8'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_8'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_товары_импортные_1"
            Begin Extent =
               Top = 6
               Left = 534
               Bottom = 85
               Right = 720
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_импортные_8"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 119
               Right = 477
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_9_размещение'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_9_размещение'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = -384
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_товары_импортные_итог"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 136
               Right = 461
            End
            DisplayFlags = 280
            TopColumn = 4
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 10
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 5925
         Alias = 5955
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_всего'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_всего'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_товары_импортные_3_общее"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 119
               Right = 229
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_импортные_5_полный_цикл"
            Begin Extent =
               Top = 6
               Left = 267
               Bottom = 119
               Right = 458
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_импортные_7_создание"
            Begin Extent =
               Top = 0
               Left = 588
               Bottom = 113
               Right = 1003
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_импортные_9_размещение"
            Begin Extent =
               Top = 170
               Left = 143
               Bottom = 283
               Right = 566
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 5220
         Alias = 4620
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
   ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_итог'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @VALUE=N'      GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_итог'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_импортные_итог'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "тТовары_для_рекламы"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 102
               Right = 208
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 4680
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "тТовары_для_рекламы"
            Begin Extent =
               Top = 8
               Left = 509
               Bottom = 104
               Right = 679
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тДоговоры"
            Begin Extent =
               Top = 5
               Left = 167
               Bottom = 135
               Right = 385
            End
            DisplayFlags = 280
            TopColumn = 2
         End
         Begin Table = "тПараметры"
            Begin Extent =
               Top = 142
               Left = 395
               Bottom = 221
               Right = 581
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_отечественные_1"
            Begin Extent =
               Top = 6
               Left = 717
               Bottom = 85
               Right = 903
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 4140
         Width = 1875
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 2415
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @VALUE=N'= 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_товары_отечественные_2"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 119
               Right = 209
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_отечественные_1"
            Begin Extent =
               Top = 6
               Left = 246
               Bottom = 85
               Right = 416
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 4650
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 3075
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_3_общее'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_3_общее'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "тТовары_для_рекламы"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 102
               Right = 224
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тДоговоры"
            Begin Extent =
               Top = 144
               Left = 444
               Bottom = 274
               Right = 678
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_отечественные_1"
            Begin Extent =
               Top = 6
               Left = 534
               Bottom = 85
               Right = 720
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тПараметры"
            Begin Extent =
               Top = 6
               Left = 758
               Bottom = 85
               Right = 944
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 3270
         Width = 5130
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 2610
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_4'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @VALUE=N'1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_4'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_4'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_товары_отечественные_4"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 119
               Right = 421
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_отечественные_1"
            Begin Extent =
               Top = 6
               Left = 459
               Bottom = 85
               Right = 629
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 3855
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 4995
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_5_полный_цикл'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_5_полный_цикл'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "тТовары_для_рекламы"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 102
               Right = 224
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тДоговоры"
            Begin Extent =
               Top = 6
               Left = 262
               Bottom = 136
               Right = 496
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_отечественные_1"
            Begin Extent =
               Top = 6
               Left = 534
               Bottom = 85
               Right = 720
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тПараметры"
            Begin Extent =
               Top = 6
               Left = 758
               Bottom = 85
               Right = 944
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 5460
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 13' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_6'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @VALUE=N'50
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_6'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_6'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_товары_отечественные_1"
            Begin Extent =
               Top = 5
               Left = 670
               Bottom = 84
               Right = 840
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_отечественные_6"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 119
               Right = 453
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 2925
         Width = 4980
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 5370
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_7_создание'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_7_создание'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "тТовары_для_рекламы"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 102
               Right = 224
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тДоговоры"
            Begin Extent =
               Top = 6
               Left = 262
               Bottom = 136
               Right = 496
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_отечественные_1"
            Begin Extent =
               Top = 6
               Left = 534
               Bottom = 85
               Right = 720
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тПараметры"
            Begin Extent =
               Top = 6
               Left = 758
               Bottom = 85
               Right = 944
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 6015
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 13' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_8'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @VALUE=N'50
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_8'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_8'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_товары_отечественные_8"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 119
               Right = 461
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_отечественные_1"
            Begin Extent =
               Top = 6
               Left = 499
               Bottom = 85
               Right = 669
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 4665
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 5805
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_9_размещение'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_9_размещение'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[41] 4[23] 2[18] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_товары_отечественные_итог"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 136
               Right = 461
            End
            DisplayFlags = 280
            TopColumn = 4
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 10
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 5685
         Alias = 5685
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_всего'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_всего'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_товары_отечественные_3_общее"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 119
               Right = 229
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_отечественные_5_полный_цикл"
            Begin Extent =
               Top = 6
               Left = 267
               Bottom = 119
               Right = 650
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_отечественные_7_создание"
            Begin Extent =
               Top = 6
               Left = 688
               Bottom = 119
               Right = 1103
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_товары_отечественные_9_размещение"
            Begin Extent =
               Top = 184
               Left = 506
               Bottom = 297
               Right = 964
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 10
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 5655
         Alias = 4440
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortTyp' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_итог'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @VALUE=N'e = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_итог'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_товары_отечественные_итог'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "тТовары_для_рекламы"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 102
               Right = 208
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 4230
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 13
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "тТовары_для_рекламы"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 102
               Right = 224
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тДоговоры"
            Begin Extent =
               Top = 6
               Left = 262
               Bottom = 136
               Right = 496
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тПараметры"
            Begin Extent =
               Top = 6
               Left = 758
               Bottom = 85
               Right = 944
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_услуги_1"
            Begin Extent =
               Top = 6
               Left = 534
               Bottom = 85
               Right = 720
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 4290
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_2_общее'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @VALUE=N' = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_2_общее'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_2_общее'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "тТовары_для_рекламы"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 102
               Right = 224
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тДоговоры"
            Begin Extent =
               Top = 6
               Left = 262
               Bottom = 136
               Right = 496
            End
            DisplayFlags = 280
            TopColumn = 2
         End
         Begin Table = "тПараметры"
            Begin Extent =
               Top = 6
               Left = 534
               Bottom = 85
               Right = 720
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_услуги_1"
            Begin Extent =
               Top = 6
               Left = 758
               Bottom = 85
               Right = 944
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_3'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @VALUE=N' = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_3'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_3'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_услуги_3"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 119
               Right = 229
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_услуги_1"
            Begin Extent =
               Top = 6
               Left = 267
               Bottom = 85
               Right = 437
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 3300
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_4_полный_цикл'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_4_полный_цикл'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "тТовары_для_рекламы"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 102
               Right = 224
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тДоговоры"
            Begin Extent =
               Top = 6
               Left = 262
               Bottom = 136
               Right = 496
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тПараметры"
            Begin Extent =
               Top = 6
               Left = 534
               Bottom = 85
               Right = 720
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_услуги_1"
            Begin Extent =
               Top = 6
               Left = 758
               Bottom = 85
               Right = 944
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_5'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @VALUE=N' = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_5'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_5'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_услуги_5"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 119
               Right = 229
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_услуги_1"
            Begin Extent =
               Top = 6
               Left = 267
               Bottom = 85
               Right = 437
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 3090
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_6_создание'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_6_создание'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "тТовары_для_рекламы"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 102
               Right = 224
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тДоговоры"
            Begin Extent =
               Top = 6
               Left = 262
               Bottom = 136
               Right = 496
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "тПараметры"
            Begin Extent =
               Top = 6
               Left = 534
               Bottom = 85
               Right = 720
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_услуги_1"
            Begin Extent =
               Top = 6
               Left = 758
               Bottom = 85
               Right = 944
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_7'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @VALUE=N' = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_7'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_7'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_услуги_7"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 119
               Right = 229
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_услуги_1"
            Begin Extent =
               Top = 6
               Left = 267
               Bottom = 85
               Right = 437
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_8_размещение'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_8_размещение'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_услуги_итог"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 136
               Right = 461
            End
            DisplayFlags = 280
            TopColumn = 5
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 10
         Width = 284
         Width = 3270
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 12
         Column = 3555
         Alias = 6180
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_всего'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_всего'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @VALUE=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties =
   Begin PaneConfigurations =
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane =
      Begin Origin =
         Top = 0
         Left = 0
      End
      Begin Tables =
         Begin Table = "зРаздел3_услуги_2_общее"
            Begin Extent =
               Top = 6
               Left = 38
               Bottom = 119
               Right = 229
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_услуги_4_полный_цикл"
            Begin Extent =
               Top = 6
               Left = 267
               Bottom = 119
               Right = 650
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_услуги_6_создание"
            Begin Extent =
               Top = 6
               Left = 688
               Bottom = 119
               Right = 1103
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "зРаздел3_услуги_8_размещение"
            Begin Extent =
               Top = 120
               Left = 38
               Bottom = 233
               Right = 461
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane =
   End
   Begin DataPane =
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane =
      Begin ColumnWidths = 11
         Column = 5775
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 13' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_итог'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @VALUE=N'50
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_итог'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @VALUE=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'зРаздел3_услуги_итог'
GO