Click here to Skip to main content
15,902,939 members

Comments by lokesh lokesh (Top 26 by date)

lokesh lokesh 24-Nov-14 2:45am View    
Can i know where u called this procedure

because in some cases while calling the procedure return data will check
for that case u must display return table as output
lokesh lokesh 24-Nov-14 1:57am View    
That’s a simple process
first execute the below function

and then
Execute this code

Declare @Temp as table (Sno int,Letter nvarchar(50),TotalChar int)
insert INTO @Temp VALUES(1,'a,a,b,b,c,c',0)
insert INTO @Temp VALUES(2,'e,e,f,g,h,i',0)

SELECT sno,Letter,
(SELECT count(DISTINCT Data) from dbo.Split((Letter),','))as Count
from @Temp

I am showing u how to retrieve the column of the table
like that above solution u can modified your query
lokesh lokesh 26-Apr-13 2:46am View    
Hi this lokesh your post is very very very use full for me


thanks dudes
lokesh lokesh 24-Feb-13 3:06am View    
thats the error i also dont know how to solve
please any solution
lokesh lokesh 2-Dec-12 23:54pm View    
hi
this is getting only url path
but i want url+remaining data also like this

string st="http://www.trap.com/handler.ashx$agshdgj,67123,sdj*"