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

what is create database syntax? : Sql server database administration

1086

---

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

980

---

Explain the categories of stored procedure?

921

---

What is a transact-sql statement batch in ms sql server?

995

---

What is table level trigger?

995

---

How to delete exactly duplicate records from a table?

1041

---

What are two difference between sql azure and azure tables?

159

---

What is the purpose of a table?

945

---

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

---

What is the maximum size of a dimension? : sql server analysis services, ssas

1025

---

What are the types of stored procedures in an sql server?

969

---

What is the process of normalising?

987

---

What is the xml datatype?

1028

---

Differentiate between a local and a global temporary table?

941

---

How can you ensure that the database and sql server based application perform well?

1054

---