Asp.net Remove , and comare district id get related values

Hi,

You can try like below in procedure if you need data for a particular row.

DECLARE @districts VARCHAR(100)

SET @districts=(SELECT district FROM statetable WHERE srno=1)

DECLARE @tbl TABLE (district VARCHAR(20) NOT NULL)

DECLARE @pos int,

@nextpos int,

@valuelen int

SELECT @pos = 0, @nextpos = 1

WHILE @nextpos > 0

BEGIN

SELECT @nextpos = charindex(',', @districts, @pos + 1)

SELECT @valuelen = CASE WHEN @nextpos > 0

THEN @nextpos

ELSE len(@districts) + 1

END - @pos - 1

INSERT @tbl (district)

VALUES (substring(@districts, @pos + 1, @valuelen))

SELECT @pos = @nextpos

END

SELECT * FROM districttable WHERE districtid IN(

SELECT district FROM @tbl)

Marked variables are names of columns and tables which you have to change accordingly

1 Reply

Know the answer? Post it — somebody with the same question will find it here.