Raj

Try this, not the best but works...

CREATE FUNCTION [dbo].[ufn_CSVToCoulmn] ( @StringInput
VARCHAR(8000),@delimiter varchar(1) )
RETURNS @OutputTable TABLE ( ID INT IDENTITY,[String] VARCHAR(1000) )
AS
BEGIN

DECLARE @String VARCHAR(1000)

WHILE LEN(@StringInput) > 0
BEGIN
SET @String = LEFT(@StringInput,
ISNULL(NULLIF(CHARINDEX(@delimiter, @StringInput) - 1, -1),
LEN(@StringInput)))
SET @StringInput = SUBSTRING(@StringInput,
ISNULL(NULLIF(CHARINDEX(@delimiter, @StringInput), 0),
LEN(@StringInput)) + 1, LEN(@StringInput))

INSERT INTO @OutputTable ( [String] )
VALUES ( @String )
END

RETURN
END
GO

Declare @var  varchar(1000)
Declare @type  varchar(1000)
Declare @Fields  varchar(1000)
DECLARE @samplingID INT
declare @Id int
SET @ID           = 5
SET  @VAR  = '5~1~2'
SET  @TYPE  = 'D~U~U'
SET
@FIELDS='Customer_name~address~city#Customer_name~address~city#Customer_name~address~city'

select @ID ID,v.[String] [VAR],t.[String] [Type],f.[String] from
(
select * from dbo.ufn_CSVToCoulmn(@var,'~')
)v inner join
(
select * from dbo.ufn_CSVToCoulmn(@TYPE,'~')
)t on t.id=v.id
inner join
(
select* from dbo.ufn_CSVToCoulmn(@FIELDS,'#')
)f on v.id=f.id

vinu
http://oneplace4sql.blogspot.com/

You have re-discovered EAV.  Google it.  Read about it.  Don't do it
again. Ever.