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 postgresql server?

1009

---

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

2002

---

what is bit datatype? : Sql server database administration

924

---

what is normalization? : Sql server database administration

1102

---

What is tablesample?

1118

---

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1058

---

define and explain the differences between clustered and non-clustered indexes.

1197

---

How many levels of sp nesting are possible?

1030

---

What is data mart? : sql server analysis services, ssas

1060

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

1008

---

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

974

---

Can a trigger be created on a view?

961

---

What do you understand by check constraint in sql server?

950

---

What is #table in sql server?

1047

---

what are the reporting service components in SSRS?

164

---