Sabba

set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoCREATE FUNCTION [dbo].[fn_ParseCommaDelimitedList](   @CommaDelimitedList varchar(4000))RETURNS @TableVar TABLE (ItemID int NOT NULL ) ASBEGIN                DECLARE @IDListPosition int                 DECLARE @IDList varchar(4000)                DECLARE @ArrValue varchar(4000)                 SET @IDList = COALESCE(@CommaDelimitedList, '')                 IF @IDList <> ''                 BEGIN                 -- Add comma to end of list so user doesn't have to                 SET @IDList = @IDList + ','                 -- Loop through the comma demlimted string list                 WHILE PATINDEX('%,%' , @IDList ) <> 0                 BEGIN                                 SELECT @IDListPosition = PATINDEX('%,%' , @IDList)                                 SELECT @ArrValue = LEFT(@IDList, @IDListPosition - 1)                                 -- Insert parsed ID into TableVar for "where in select"                                INSERT INTO @TableVar (ItemID) VALUES (CONVERT(int, @ArrValue))                                 -- Remove processed string                                 SELECT @IDList = STUFF(@IDList, 1, @IDListPosition, '')                 END                 END RETURN END