Click here to Skip to main content
11,704,044 members (66,831 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 Maciej Los 530
1 OriginalGriff 510
2 Sergey Alexandrovich Kryukov 421
3 Andy Lanng 294
4 F-ES Sitecore 220
0 OriginalGriff 8,744
1 Sergey Alexandrovich Kryukov 7,747
2 CPallini 5,107
3 Maciej Los 4,716
4 Mika Wendelius 3,606


Advertise | Privacy | Mobile
Web04 | 2.8.150819.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