Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Indexing by Alphabet

Author  Topic 

BJM RAO
Starting Member

20 Posts

Posted - 2009-04-16 : 11:37:02
I got a list of 100 persons (say so ...) in the order of SL.No

Likely
SL. Name Pg
01 Rao 01
02 Jagan 01
03 Mohan 05
04 Raj 09
05 Boby 12
06 Ankur 10 and so on

but i wish them to get indexed by alphabet (name )
A
Name Pg No
Ankur 10

B
Bobby 12
.
.
.
R
Rao 01 and so on

in order to obtain the details of the person through name (case where i know only his name )


   

- Advertisement -