CREATE PROCEDURE dbo.s_Risk
(
	@ID VARCHAR(200),
	@sP VARCHAR(50),
	@ClassID VARCHAR(25)
)
AS

SET NOCOUNT ON

SELECT	@ID = NULLIF(@ID, ''),
	@sP = NULLIF(@sP, ''),
	@ClassID = NULLIF(@ClassID, '')
        
CREATE TABLE	#ID
		(
			ID VARCHAR(200)
		)

SET	@ID = ',' + @ID + ','

INSERT	#ID
SELECT	DISTINCT
	SUBSTRING(@ID, Number + 1, CHARINDEX(',', @ID, Number + 1) - Number - 1)
FROM	Tally 
WHERE	Number < DATALENGTH(@ID)
	AND SUBSTRING(@ID, Number, 1) = ','

CREATE TABLE	#pForm
		(
			sP VARCHAR(50)
		)

SET	@sP = ',' + @sP + ','

INSERT	#pForm
SELECT	DISTINCT
	SUBSTRING(@sP, Number + 1, CHARINDEX(',', @sP, Number + 1) - Number - 1)
FROM	Tally 
WHERE	Number < DATALENGTH(@sP)
	AND SUBSTRING(@sP, Number, 1) = ','

CREATE TABLE	#ClassID
		(
		        Class INT
		)
        
SET	@ClassID = ',' + @ClassID + ','

INSERT	#ClassID
SELECT	DISTINCT
	SUBSTRING(@ClassID, Number + 1, CHARINDEX(',', @ClassID, Number + 1) - Number - 1)
FROM	Tally 
WHERE	Number < DATALENGTH(@ClassID)
	AND SUBSTRING(@ClassID, Number, 1) = ','

SELECT		r.ID,
		r.sP,
		r.ClassID,
		r.MoneyValue,
		r.NetAmount,
		r.Datestarted,
		r.DateEnded
FROM		Risk AS r
LEFT JOIN	#ID

IF @ID IS NULL AND @sP IS NULL AND @ClassID IS Null
	SELECT	ID,
		sP,
		ClassId,
		MoneyValue,
		NetAmount,
		Datestarted,
		DateEnded
	FROM	Risk
ELSE
	SELECT	r.ID,
		r.sP,
		r.ClassId,
		r.MoneyValue,
		r.NetAmount,
		r.Datestarted,
		r.DateEnded
	FROM	Risk AS r
	WHERE	EXISTS (SELECT * FROM #ID AS i WHERE i.ID = r.ID)
		OR EXISTS (SELECT * FROM #pForm AS p WHERE p.sP = r.sP)
		OR EXISTS (SELECT * FROM #ClassID AS c WHERE c.ClassID = r.ClassID)