帮忙解决这个存储过程问题！

Question

CREATE PROCEDURE GetCominfo
@kind nvarchar(100)
AS
create table #cominfo --创建临时表
                      (
                        comID            int,
                        img              nvarchar(200),
                        zk              float ,
                        fenwei          nvarchar(80) ,
                        kouwei          nvarchar(220),
                        zktj            nvarchar(100),
                        rjxf            nvarchar(50),
                        eat              bit,
                        drink            bit,
                        comname          nvarchar(50),
            zhuying          nvarchar(200),
                        tel              nvarchar(50),
                        address          nvarchar(100),
                        city            nvarchar(50),
                        floor            nvarchar(50),
                        et          nvarchar(20),
                        ywsort          nvarchar(255)
                    )insert into #cominfo
(
comID,img,zk,fenwei,kouwei,zktj,rjxf,eat,drink,comname,zhuying,tel,address,city,floor,et,ywsort
  )  --插入临时表数据
select comID=companyID,img=picture,zk=zhekou,fenwei=cominfo.fenwei,kouwei=kouwei,zktj=ZKtiaojian,rjxf=renjunCost,eat=eat,drink=drink,comname=CompanyName,zhuying=zhuying,tel=Tel,address=Address,city=city.city,floor=floor.floor,et=et.et,ywsort=ywsort
from cominfo,company,city,Floor,Market where city.id= company.city and Floor.id=*company.Floor and Market.id=*company.Market and cominfo.companyID=*company.id 
select * from #cominfo where ywsort like @kind  --查询临时表GO
drop table #cominfo --删除临时表 
把倒数第三行的GO去掉，因为那样会当作一次批处理，@kind的声明就会失效。