dbo.x_noinv_nobc

SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE VIEW dbo.x_noinv_nobc
AS
WITH cte_bc(tipe, CAR, BC23No, BC23Tg, DokKd, DokNo, DokTg) AS (SELECT     dbo.tbl_bc_in_hdr.typedok, dbo.tbl_bc_in_hdr.CAR, dbo.tbl_bc_in_hdr.BC23No, 
                                                                                                                                                                            dbo.tbl_bc_in_hdr.BC23Tg, dbo.tbl_bc_in_dok.DokKd, dbo.tbl_bc_in_dok.DokNo, 
                                                                                                                                                                            dbo.tbl_bc_in_dok.DokTg
                                                                                                                                                     FROM         dbo.tbl_bc_in_hdr INNER JOIN
                                                                                                                                                                            dbo.tbl_bc_in_dok ON dbo.tbl_bc_in_hdr.id_bc_in_hdr = dbo.tbl_bc_in_dok.id_bc_in_hdr
                                                                                                                                                     WHERE     (dbo.tbl_bc_in_dok.DokKd = '380') AND (dbo.tbl_bc_in_hdr.BC23Tg BETWEEN '2014-10-01' AND 
                                                                                                                                                                            '2017-12-31')), cte_inv AS
    (SELECT     inv_hdr_id, r2, r3, r4, r5
      FROM          dbo.tbl_inv_hdr)
    SELECT     cte_bc_1.tipe, cte_bc_1.CAR, cte_bc_1.BC23No AS nobc, CONVERT(char(10), cte_bc_1.BC23Tg, 126) AS tglbc, cte_bc_1.DokKd, cte_bc_1.DokNo, CONVERT(char(10), 
                            cte_bc_1.DokTg, 126) AS doktgl, cte_inv_1.r3 AS inv_no, cte_inv_1.r4 AS inv_alias, cte_inv_1.r2 AS kdsup, cte_inv_1.inv_hdr_id
     FROM         cte_bc AS cte_bc_1 LEFT OUTER JOIN
                            cte_inv AS cte_inv_1 ON cte_inv_1.r3 = cte_bc_1.DokNo
GO

EXEC sys.sp_addextendedproperty N'MS_DiagramPane1', 
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 = "cte_bc_1" Begin Extent = Top = 6 Left = 38 Bottom = 114 Right = 189 End DisplayFlags = 280 TopColumn = 0 End Begin Table = "cte_inv_1" Begin Extent = Top = 6 Left = 227 Bottom = 114 Right = 378 End DisplayFlags = 280 TopColumn = 0 End End End Begin SQLPane = End Begin DataPane = Begin ParameterDefaults = "" End Begin ColumnWidths = 11 Width = 284 Width = 1500 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 = 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 ', 'SCHEMA', N'dbo', 'VIEW', N'x_noinv_nobc'
GO

EXEC sys.sp_addextendedproperty N'MS_DiagramPaneCount', 1, 'SCHEMA', N'dbo', 'VIEW', N'x_noinv_nobc'
GO