ÿþUSE [SMS_XYZ]

GO

/****** Object:  View [dbo].[v_RequiredUpdates]    Script Date: 10/27/2008 23:53:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE VIEW [dbo].[v_RequiredUpdates]

AS

SELECT DISTINCT 

                      TOP (100) PERCENT dbo.v_UpdateInfo.DatePosted, dbo.v_UpdateInfo.BulletinID, dbo.v_UpdateInfo.ArticleID, dbo.v_UpdateInfo.Title, 

                      dbo.CI_ContentFiles.SourceURL, dbo.v_UpdateContents.ContentLocales, dbo.v_UpdateInfo.IsExpired, dbo.v_UpdateContents.ContentProvisioned

FROM         dbo.v_Update_ComplianceStatusAll INNER JOIN

                      dbo.v_UpdateContents ON dbo.v_Update_ComplianceStatusAll.CI_ID = dbo.v_UpdateContents.CI_ID INNER JOIN

                      dbo.v_UpdateInfo ON dbo.v_UpdateContents.CI_ID = dbo.v_UpdateInfo.CI_ID INNER JOIN

                      dbo.CI_ContentFiles ON dbo.v_UpdateContents.Content_ID = dbo.CI_ContentFiles.Content_ID

WHERE     (dbo.v_Update_ComplianceStatusAll.Status = 2) AND (dbo.v_UpdateContents.ContentLocales = 'English' OR

                      dbo.v_UpdateContents.ContentLocales = ' ') AND (dbo.v_UpdateInfo.IsExpired = 'False') AND (dbo.v_UpdateContents.ContentProvisioned = 0)

ORDER BY dbo.v_UpdateInfo.ArticleID DESC



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[8] 4[37] 2[30] 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 = "v_Update_ComplianceStatusAll"

            Begin Extent = 

               Top = 21

               Left = 655

               Bottom = 216

               Right = 880

            End

            DisplayFlags = 280

            TopColumn = 2

         End

         Begin Table = "v_UpdateContents"

            Begin Extent = 

               Top = 6

               Left = 38

               Bottom = 190

               Right = 212

            End

            DisplayFlags = 280

            TopColumn = 0

         End

         Begin Table = "v_UpdateInfo"

            Begin Extent = 

               Top = 32

               Left = 288

               Bottom = 223

               Right = 495

            End

            DisplayFlags = 280

            TopColumn = 13

         End

         Begin Table = "CI_ContentFiles"

            Begin Extent = 

               Top = 16

               Left = 537

               Bottom = 181

               Right = 688

            End

            DisplayFlags = 280

            TopColumn = 4

         End

      End

   End

   Begin SQLPane = 

   End

   Begin DataPane = 

      Begin ParameterDefaults = ""

      End

      Begin ColumnWidths = 9

         Width = 284

         Width = 1500

         Width = 1500

         Width = 1185

         Width = 4095

         Width = 13605

         Width = 1125

         Width = 2025

         Width = 1500

      End

   End

   Begin CriteriaPane = 

      Begin ColumnWidths = 11

         Column = 1440

         Alias = 900

         Table = 2715

         Output = 720

         Append = 1400

         NewValue = 1170

         SortType = 1350

         SortOrder = 1410

         GroupBy = 1350

         Filter = 1350

         Or = 1350

         ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_RequiredUpdates'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'Or = 1350

         Or = 1350

      End

   End

End

' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_RequiredUpdates'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_RequiredUpdates'