Click here to Skip to main content
11,642,855 members (74,907 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: StoredProcedures
Hi,
I have a table with data as below.

NO ID
-- ------
1 baca
2 ada
3 ebe
4 ec


select column ID between 1 and 4.then pass each
row of ID column into below function as

select distinct Val from dbo.ParseValues('baca','')
where Val !=''


 
CREATE FUNCTION ParseValues1
(@String varchar(8000), @Delimiter varchar(10) )
RETURNS @RESULTS TABLE (ID int identity(1,1), Val varchar(50))
AS
BEGIN
DECLARE @Value varchar(100)
WHILE @String is not null
BEGIN
SELECT @Value=CASE WHEN PATINDEX('%'+@Delimiter+'%',@String) >0 THEN LEFT(@String,PATINDEX('%'+@Delimiter+'%',@String)-1) ELSE @String END, @String=CASE WHEN PATINDEX('%'+@Delimiter+'%',@String) >0 THEN SUBSTRING(@String,PATINDEX('%'+@Delimiter+'%',@String)+LEN(@Delimiter),LEN(@String)) ELSE NULL END
INSERT INTO @RESULTS (Val)
SELECT @Value
END
RETURN
END
it give distinct ID from each row.

then combine each row result into a table and get result table as below

ID
--
b
a
c
a
d
e
b

then, finally find distinct count of ID column as 5(a,b,c,d,e).

how to write a stored procedure for getting above result?

thanks.
Posted 6-Feb-13 21:19pm
hasbina1.3K
Edited 6-Feb-13 22:11pm
v5

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 DamithSL 258
1 Sergey Alexandrovich Kryukov 230
2 jyo.net 180
3 OriginalGriff 170
4 Afzaal Ahmad Zeeshan 155
0 Mika Wendelius 485
1 DamithSL 457
2 OriginalGriff 365
3 Afzaal Ahmad Zeeshan 258
4 Sergey Alexandrovich Kryukov 254


Advertise | Privacy | Mobile
Web03 | 2.8.150731.1 | Last Updated 7 Feb 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100