Answer Posted / santosh kairamkonda

In SQL Server 2005 New query window for any database.

declare @char as charchar(20)
set @char='bhaskar'

declare @i as int
declare @cnt as int

set @i=1
set @cnt=1

Create table #temp (charval varchar(4) )

while (@i < len(@char) )
begin
set @cnt = @cnt + (select count(1) from #temp where
substring(charval,1,1) = substring(@char,@i,1))

if (@cnt>1)
begin
update #temp set charval = (substring
(@char,@i,1)+':'+ Convert(varchar(20),@cnt) ) where
substring(charval,1,1) = substring(@char,@i,1)
end
else
begin
Insert into #temp values (substring
(@char,@i,1)+':'+ Convert(varchar(20),@cnt) )
end

print @i
set @i = @i+1

set @cnt=1
end

select * from #temp

=======================
You will get result as required.

What do you mean by a dependent functionality in a build?

1200

---

How do I find the query plan in sql server?

1019

---

How we create SQL Server 2005 Reporting Services ? Give me Sample

2045

---

Tell me about builtinadministrator?

1046

---

Can two tables share a primary key?

1084

---

When I delete any data from a table, does the sql server reduce the size of that table?

1064

---

Which Model uses the SET concept

1045

---

Explain the various types of concurrency problem?

1243

---

What are the export options of ssrs?

178

---

What do mean by xml datatype?

1176

---

How do I run sql server 2014?

1055

---

What are trace flags and mention a few common trace flags used with sql server?

1142

---

What is 2nf normalization?

1090

---

How to Sync Two SQL Azure Databases?

121

---

Do you know what are acid properties of transaction?

1005

---