

/****** Object:  View [dbo].[DocLinkProperties]    Script Date: 6/26/2017 7:55:58 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[DocLinkProperties]
AS
SELECT     '1' AS Script, pv.ParentID AS DLDocID, dt.description AS DLDocDescr, dt.Name AS DLDocType, dt.DocumentTypeTag AS DLDocTypeCodes, 
                      p.PropertyTag AS DLPropertyCodes, p.PropertyName AS DLPropertyName, p.UserPrompt, 'varchar' AS DataType, 
                      PropertyCharValue AS PropertyValues
FROM doclink2.dbo.PropertyCharValues pv WITH (NOLOCK, INDEX = IX_PropertyCharValuesParentID) INNER JOIN
                      doclink2.dbo.DocumentTypePropertys dtp ON pv.DocumentTypePropertyId = dtp.DocumentTypePropertyId INNER JOIN
                      doclink2.dbo.Propertys p ON dtp.PropertyId = p.PropertyId INNER JOIN
                      doclink2.dbo.DocumentTypes AS dt ON dtp.ParentId = dt.DocumentTypeId
WHERE     p.PropertyTag IS NOT NULL

UNION ALL

SELECT     '2' AS Script, pv.ParentID AS DLDocID, dt.description AS DLDocDescr, dt.Name AS DLDocType, dt.DocumentTypeTag AS DLDocTypeCodes, 
                      p.PropertyTag AS DLPropertyCodes, p.PropertyName AS DLPropertyName, p.UserPrompt, 'float' AS DataType, 
                      CONVERT(nvarchar(100),PropertyFloatValue) AS PropertyValues
FROM         doclink2.dbo.PropertyFloatValues pv WITH (NOLOCK, INDEX = IX_PropertyFloatValuesParentID) INNER JOIN
                      doclink2.dbo.DocumentTypePropertys dtp ON pv.DocumentTypePropertyId = dtp.DocumentTypePropertyId INNER JOIN
                      doclink2.dbo.Propertys p ON dtp.PropertyId = p.PropertyId INNER JOIN
                      doclink2.dbo.DocumentTypes AS dt ON dtp.ParentId = dt.DocumentTypeId
WHERE     p.PropertyTag IS NOT NULL

UNION ALL

SELECT     '3' AS Script, pv.ParentID AS DLDocID, dt.description AS DLDocDescr, dt.Name AS DLDocType, dt.DocumentTypeTag AS DLDocTypeCodes, 
                      p.PropertyTag AS DLPropertyCodes, p.PropertyName AS DLPropertyName, p.UserPrompt, 'date' AS DataType,
                      CONVERT(nvarchar(100), PropertyDateValue) AS PropertyValues
FROM doclink2.dbo.PropertyDateValues pv WITH (NOLOCK, INDEX = IX_PropertyDateValuesParentID) INNER JOIN
                      doclink2.dbo.DocumentTypePropertys dtp ON pv.DocumentTypePropertyId = dtp.DocumentTypePropertyId INNER JOIN
                      doclink2.dbo.Propertys p ON dtp.PropertyId = p.PropertyId INNER JOIN
                      doclink2.dbo.DocumentTypes AS dt ON dtp.ParentId = dt.DocumentTypeId
WHERE     p.PropertyTag IS NOT NULL

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[43] 4[20] 2[11] 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'DocLinkProperties'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'DocLinkProperties'
GO


