编号与店名排序SQL问题

[szlixiaolong]

数据集名称1区域：area,SQL语句如下：

SELECT top 1 '*' as area_no,'全部' as area_name
FROM happy_area_flag where area_no not in ('04')

union all

SELECT [area_no],area_name
FROM happy_area_flag where area_no not in ('04')


数据集名称2店名：shop,SQL语句如下：

if @area='*'

select top 1 '*' as branch_no ,'全部' as branch_name from happy_branch_area

if @area<>'*'

SELECT (ltrim(rtrim(branch_no))) as branch_no ,'['+(convert(varchar,(ltrim(rtrim(branch_no)))+']'+branch_name )) as branch_name
FROM [bw9kbzpro_04].[dbo].[happy_branch_area] a ,happy_area_flag b
where a.area_no=b.area_no
and branch_no not in ('99', '93', 'AE')
and len(branch_no) = '4'
and b.area_no in (@area)

union all

SELECT (ltrim(rtrim(branch_no))) as branch_no ,'['+(convert(varchar,(ltrim(rtrim(branch_no)))+']'+branch_name )) as branch_name
FROM [bw9kbzpro_04].[dbo].[happy_branch_area] a ,happy_area_flag b
where a.area_no=b.area_no and branch_no like '00%'
and branch_no not in ('99', '93', 'AE')
and len(branch_no) = '2'
and b.area_no in (@area) order by branch_name desc

SQL运行后，点击区域时，就会看到相应的店名，希望可以做到按店名依次排列显示。

[szlixiaolong]

[szlixiaolong]

SQL运行后，点击区域时，就会看到相应的店名，希望可以做到按店名依次排列显示，例如：【B001】广州高铁南1-104店总仓库 【BL01】广州南站2-21总仓库 。。。。。。 【BP01】广珠沿线