How can count the string ?
for ex: If i have string like 'bhaskar' then i need like
b:1
h:1
a:2
s:1
k:1
r:1
please give any idea on that
Answer Posted / pradyumna
declare @temp table
(name char(1),counter int)
declare @str varchar(10)
set @str='bhaskar'
declare @strlen int
set @strlen=len(@str)
declare @ctr int
set @ctr=1
declare @Alpha char(1)
while @ctr<=@strlen
begin
set @alpha=substring(@str,@ctr,@strlen-(@strlen-
@ctr))
if not exists (select 1 from @temp where name=@alpha)
begin
insert into @temp values(@alpha,1)
end
else
begin
update @temp set counter=counter+1 where name=@alpha
end
set @ctr=@ctr+1
end
select * from @temp
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the different types of stored procedures?
What is co-related sub query?
what are different types of backups available in sql server? : Sql server database administration
What are the new features of sql server 2008 r2 reporting service?
How to get a list all databases on the sql server?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What is an example of a primary key?
Explain a differential backup?
Describe how to use linked server?
What is SQL Azure Data sync?
What are types of subqueries?
Which is better statement or preparedstatement?
Differentiate between ms sql server reporting services vs crystal reports?
What is unique key constraint?
How to enable tcp/ip protocol on a sql server?