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

How to create a new schema in a database?

1069

---

What is the difference between system objects and user objects?

1096

---

What do you understand by physical_only option in dbcc checkdb?

932

---

What is the latest version of microsoft sql server?

956

---

How to use subqueries with the exists operators in ms sql server?

1055

---

How does the report manager work in SSRS?

140

---

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1011

---

What is use of except clause? How does it differ from not in clause?

960

---

Explain Normalization and DE normalization

1052

---

What is intellisense?

988

---

What is triggers and stored procedures?

886

---

What is fill factor and pad index?

949

---

How to receive returning result from a query?

1032

---

Explain about temporary stored procedure?

930

---

Tell me when is the update_statistics command used?

1015

---