zhanzhan.txt

asp的公交管理系统 方便同学们写论文 用于出外公干不熟悉路线的人们

CREATE PROCEDURE zhanzhan @x varchar(14) ,@y varchar(14) AS
select * into #T1 from tbbus 
where 站点 like  '%'+@x+'%'
order by 路线,编号

select * into #T2 from tbbus
where 站点 like '%'+@y+'%'
order by 路线,编号
select distinct #T1.路线,#T1.站点 as 起始站,#T2.站点 as 终点站
from #T1,#T2
where #T1.路线=#T2.路线 and #T1.编号<#T2.编号
GO