Microsoft.SystemCenter.DataWarehouse.Report.Script.GetUnitsList (DataWarehouseScript)

Element properties:

Source Code:

<DataWarehouseScript ID="Microsoft.SystemCenter.DataWarehouse.Report.Script.GetUnitsList" Accessibility="Public">

  <Install> 

                IF NOT EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Microsoft_SystemCenter_DataWarehouse_Report_GetUnitsList')

	BEGIN

		EXECUTE ('CREATE PROCEDURE dbo.[Microsoft_SystemCenter_DataWarehouse_Report_GetUnitsList] AS RETURN 1')

	END

GO



ALTER PROCEDURE [dbo].[Microsoft_SystemCenter_DataWarehouse_Report_GetUnitsList]

	@UnitList xml

AS

BEGIN

  SET NOCOUNT ON



    DECLARE @Error int

    DECLARE @ExecError int



    SET @Error = @@ERROR

	IF @Error &lt;&gt; 0 GOTO QuitError





	Select	UnitList.Units.value('./*[1]','int') as UnitValue,

			UnitList.Units.value('./*[2]','nvarchar(200)') as UnitLabel

	From @UnitList.nodes('/Data/*/*') As UnitList(Units)

	Order By UnitValue



QuitError:



   	RETURN @Error

END

GO



GRANT EXECUTE ON dbo.[Microsoft_SystemCenter_DataWarehouse_Report_GetUnitsList] TO OpsMgrReader

GO



                </Install>

  <Uninstall>

                 IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Microsoft_SystemCenter_DataWarehouse_Report_GetUnitsList')

	BEGIN

        DROP PROCEDURE dbo.[Microsoft_SystemCenter_DataWarehouse_Report_GetUnitsList]

	END

GO



                </Uninstall>

  <Upgrade> 

                IF NOT EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Microsoft_SystemCenter_DataWarehouse_Report_GetUnitsList')

	BEGIN

		EXECUTE ('CREATE PROCEDURE dbo.[Microsoft_SystemCenter_DataWarehouse_Report_GetUnitsList] AS RETURN 1')

	END

GO



ALTER PROCEDURE [dbo].[Microsoft_SystemCenter_DataWarehouse_Report_GetUnitsList]

	@UnitList xml

AS

BEGIN

  SET NOCOUNT ON



    DECLARE @Error int

    DECLARE @ExecError int



    SET @Error = @@ERROR

	IF @Error &lt;&gt; 0 GOTO QuitError





	Select	UnitList.Units.value('./*[1]','int') as UnitValue,

			UnitList.Units.value('./*[2]','nvarchar(200)') as UnitLabel

	From @UnitList.nodes('/Data/*/*') As UnitList(Units)

	Order By UnitValue



QuitError:



   	RETURN @Error

END

GO



GRANT EXECUTE ON dbo.[Microsoft_SystemCenter_DataWarehouse_Report_GetUnitsList] TO OpsMgrReader

GO



                </Upgrade>

</DataWarehouseScript>