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
- 9 Answers
- 9895 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sanjay kumar dindaa
Declare @strInput as varchar(20)
declare @intLocal as int
declare @chrLocal as char
DECLARE @strLocal varchar(10)
DECLARE @strFinal varchar(100)
Set @intLocal=1
Set @chrLocal=1
Set @strInput='bhaskar'
If exists (Select 1 from sys.tables where name ='temp')
DROP TABLE temp
Create table temp(chrValue Char(1), Cnt Int)
while (@intLocal < len(@strInput) )
begin
set @chrLocal = Substring(@strInput,@intLocal,1)
IF (Select Count(1) from temp Where chrvalue=@chrLocal)> 0
UPDATE TEMP
Set Cnt=Cnt+1
Where chrValue=@chrLocal
else
Insert Into temp (chrValue, Cnt ) values ( @chrLocal,1)
set @intLocal = @intLocal+1
end
Set @strFinal=''
DECLARE @curLocal CURSOR
SET @curLocal = CURSOR FOR
Select ChrValue + ': '+ Cast(cnt as varchar(2)) from temp
OPEN @curLocal
FETCH NEXT
FROM @curLocal INTO @strLocal
WHILE @@FETCH_STATUS = 0
BEGIN
----PRINT @strLocal
Set @strFinal =@strFinal + ' ' + @strLocal
FETCH NEXT
FROM @curLocal INTO @strLocal
END
CLOSE @curLocal
DEALLOCATE @curLocal
PRINT @strFinal
Output :
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
b: 1 h: 1 a: 2 s: 1 k: 1
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Define self join?
What is intellisense?
What happens if strings are casted into wrong code pages in ms sql server?
What happens on checkpoint?
What are null values in ms sql server?
What is bcp? When does it used?
If we delete pack Spec what will be the status of pack Body ?
Why normalization is used?
What is master database? : SQL Server Architecture
What are the advantages of the mirroring?
What objects does the fn_my_permissions function reports on? : sql server security
between cast and convert which function would you prefer and why?
What is temporary table in sql server? Why we use temp table?
How to rebuild the master database?
How to truncate the log in sql server 2012? : sql server database administration
