Function for history (internal use only-not at customer sites)

01/11/2024 9:36 am EST

Create FUNCTION [dbo].[fnNTextToIntTable] (@Data NTEXT) RETURNS @IntTable TABLE([Value] INT NULL) AS BEGIN DECLARE @Ptr int, @Length int, @v nchar, @vv nvarchar(10) SELECT @Length = (DATALENGTH(@Data) / 2) + 1, @Ptr = 1 WHILE(@Ptr < @Length) BEGIN SET @v = SUBSTRING(@Data, @Ptr, 1) IF @v = ',' BEGIN INSERT INTO @IntTable(Value) VALUES(CAST(@vv AS int)) SET @vv = NULL END ELSE BEGIN SET @vv = ISNULL(@vv, '') + @v END SET @Ptr = @Ptr + 1 END IF @vv IS NOT NULL INSERT INTO @IntTable(Value) VALUES(CAST(@vv AS int)) RETURN END

Was this article helpful?