两给小问题！！！帮帮忙！！

[youngby]

use pubs
go
select * from jobs
go

结果如下：
job_id job_desc min_lvl max_lvl
------ -------------------------------------------------- ------- -------
1 New Hire - Job not specified 10 10
2 Chief Executive Officer 200 250
3 Business Operations Manager 175 225
4 Chief Financial Officier 175 250
5 Publisher 150 250
6 Managing Editor 140 225
7 Marketing Manager 120 200
8 Public Relations Manager 100 175
9 Acquisitions Manager 75 175
10 Productions Manager 75 165
11 Operations Manager 75 150
12 Editor 25 100
13 Sales Representative 25 100
14 Designer 25 100

请问如何倒转结果集？
成：
job_id ..........
job_desc ........




第二个。返回多个结果集的存储过程，如何只返回指定的过程？或者合并结果集（用SQL）比如sp_help 一个表
返回了过个结果集

[youngby]

自己UP自己

[shuiniu]

1.
http://expert.csdn.net/Expert/topic/2440/2440306.xml?temp=.6941645

[shuiniu]

2.
比较难！要给存储过程！

[txlicenhe]

1:
http://expert.csdn.net/Expert/topic/2440/2440306.xml?temp=.6941645
2:
http://expert.csdn.net/Expert/topic/2486/2486349.xml?temp=.9402429

[youngby]

谢谢，两位。

第二个问题。
如果用前台应用程序来实现的话，并不难呀。
就是用SQL如何实现？