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