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 is the rdl file?

138

---

What is tablix?

162

---

Differentiate between sql temp table vs table variable?

884

---

Can you pass expressions to function parameters?

1103

---

What does indexation mean?

973

---

How to use copy and concatenate commands in SQL?

1142

---

How to sort the query output with order by clauses in ms sql server?

1035

---

How to create function with parameter in sql server?

1109

---

How to provide values to stored procedure parameters in ms sql server?

1037

---

What is a heap?

1034

---

What is data source document?

1043

---

What is sqlservr.exe - process - sql server (sqlex?press)?

1110

---

Explain sub-query?

958

---

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

1068

---

Do you know what is difference between index seek vs. Index scan?

954

---