BANK FAMA

??USE [MinovaES_BankFama_Prod]

GO

/****** Object:  StoredProcedure [dbo].[PDSCUSTROLEID]    Script Date: 18/10/2022 09.52.21 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[PDSCUSTROLEID]

(

	@RoleID VARCHAR(250)

	,@RoleDescription VARCHAR(250)

	,@CompanyID VARCHAR(8)

)

AS

--DECLARE @RoleID VARCHAR(250) = ''

--DECLARE @RoleDescription VARCHAR(250) = ''

--DECLARE @CompanyID VARCHAR(8) = '1000'

SELECT StartDate, EndDate, RoleID, RoleDescription, CASE WHEN CompanyID = '*' THEN @CompanyID ELSE CompanyID END CompanyID, Notes, CreateBy, CreateDate, ChangeBy, ChangeDate FROM PCUSTROLEID 

WHERE (CompanyID = @CompanyID OR CompanyID = '*' OR @CompanyID = '')

	AND (RoleID like @RoleID OR @RoleID = '')

	AND (RoleDescription like @RoleDescription OR @RoleDescription = '')