affiliate marketing Dot Net Posts: Save multiples values into table in sql server using function

Friday, 24 June 2011

Save multiples values into table in sql server using function

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
CREATE FUNCTION [dbo].[Fxn_Global_SeperatedValues]
(@values varchar(Max) )
RETURNS @um_temp Table (person_id int)
AS
Begin
DECLARE @NextString VARCHAR(100)
DECLARE @Pos INT
DECLARE @Delimiter VARCHAR(10)
SET @Delimiter = ','
--SET @Values = @Values + @Delimiter
SET @Pos = CHARINDEX(@Delimiter,@Values)
WHILE (@pos <> 0)
BEGIN
SET @NextString = substring(@Values,1,@Pos - 1)
insert into @um_temp (person_id) values(@NextString)
SET @Values = substring(@Values,@pos+1,len(@Values))
SET @pos = charindex(@Delimiter,@Values)
End
return
End

No comments:

Post a Comment