Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This sample demonstrates the changes made to the SCRM 2006 stored procedure SCRS_GetProgramName in How to Switch the Filter Order of an SCRM Report. The original stored procedure is in the SCRM 2006 SystemCenterPresentation database.
Requirements
SCRM 2006.
Example
SCRS_GetProgramName is changed so that it no longer requires the company name as an input parameter and instead returns the full list of program names.
USE [SystemCenterPresentation]
GO
/****** Object: StoredProcedure [dbo].[SCRS_GetProgramName_CUSTOM] Script Date: 04/06/2006 12:04:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SCRS_GetProgramName_CUSTOM]
--Declare input parameters for the Stored Procedure.
(@LocaleID int )
AS
-- Prevent number of rows affected being returned as part of results.
SET NOCOUNT ON
SELECT 1 AS Sequence,'<ALL>' AS ProgramName , dbo.fn_getLocalizedString('<ALL>','Misc',@LocaleID) AS ProgramNameLabel
UNION ALL
SELECT DISTINCT 2 AS Sequence,
ARPUserDisplayName AS ProgramName , ARPUserDisplayName AS ProgramNameLabel
FROM
[dbo].[SCRS_AddRemoveProgram_DIMENSION_View]
WHERE
ARPUserDisplayName IS NOT NULL
ORDER BY Sequence, ProgramNameLabel
--Restore Database Settings
SET NOCOUNT OFF
See Also
Tasks
How to Create an SCRM Stored Procedure
How to Switch the Filter Order of an SCRM Report
Reference
SCRM 2006 SCRS_AddRemoveProgram_DIMENSION_View
SCRS_GetProgramName Stored Procedure