Code Sample: SCRS_GetProgramName_CUSTOM SCRM Stored Procedure

System Center

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

Show: