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 are ddl (data definition language) statements for tables in ms sql server?

1031

---

What are points to remember while using the fillfactor argument?

911

---

What are the types of user defined functions in sql server?

991

---

How to create percentile function?

139

---

how to control the amount of free space in your index pages? : Sql server database administration

985

---

How secure is sql server database?

958

---

What are triggers? How do you invoke a trigger on demand?

1247

---

Can we insert data into view sql server?

885

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1014

---

What are trace files?

898

---

What is the difference between stored procedure and user defined functions?

1132

---

What are the different SQL Server Versions you have worked on?

955

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

913

---

what do you understand by change data capture?

941

---

What is the use of floor function in sql server?

1025

---