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 2000 Forums
 Transact-SQL (2000)
 Please help with Select statement

Author  Topic 

skylimitsql
Starting Member

8 Posts

Posted - 2010-09-02 : 07:26:32
Please help me in building this select statement

I need to control it rather then hard code.
Result should be like this --
0xx
1xx
2xx
3xx
4xx
5xx
6xx
7xx
8xx
9xx

Then
Axx
Bxx
Cxx
Dxx
Fxx

Then
0xx
1xx
2xx
3xx
4xx
5xx
6xx
7xx
8xx
9xx

Then
Axx
....
....
Fxx

Then
oxx
...
...
9xx

So First 0xx - 9xx then Axx - Fxx then again 0xx - 9xx then again Axx-Fxx

Thanks

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-09-02 : 09:02:20
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=149636

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -