借用字符串进行无规律排序

view plaincopy to clipboardprint?
--(1)借用字符串进行无规律排序  
create table #DepartMent  
(  
 Depart varchar(10)  
)  
insert into #DepartMent select '组长' 
union all select '助理' 
union all select '总经理' 
union all select '员工' 
union all select '副总经理' 
union all select '主管' 
declare @sql varchar(100)  
set @sql=N'总经理,副总经理,主管,组长,助理,员工' 
 
select * from #DepartMent  
order by charindex(N','+Depart+N',',N','+@sql+N',') 

 

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/ws_hgo/archive/2009/02/06/3866925.aspx