CREATE PROCEDURE ReportPayMoneyDetail
@BeginDate datetime,
@EndDate datetime,
@IsLandTax varchar(10),
@Qtype varchar(10),
@condition varchar(255)
ASSELECT a.taxBillCode, a.taxBillDate, b.rname AS companyName, b.code, a.totalMoney,
a.centerMoney, a.provinceMoney, a.cityMoney, a.taxItemsID,
c.rname AS regionName
FROM tbTaxBill a INNER JOIN
symCompany b ON a.companyID = b.rid INNER JOIN
symRegion c ON b.regionID = c.rid
WHERE
taxBillDate>=@BeginDate AND taxBillDate<@EndDate AND a.IsLandTax=@IsLandTax AND @Qtype LIKE '%'+@condition+'%'
GO倒数第二行有问题
我在查询分析器中用
exec ReportPayMoneyDetail '2001-01-01','2009-01-01','Y','c.rname','工'
执行结果为空,但是把存储过程中的 @Qtype 换成 c.rname 就可以出来。
高手请帮忙
@BeginDate datetime,
@EndDate datetime,
@IsLandTax varchar(10),
@Qtype varchar(10),
@condition varchar(255)
ASSELECT a.taxBillCode, a.taxBillDate, b.rname AS companyName, b.code, a.totalMoney,
a.centerMoney, a.provinceMoney, a.cityMoney, a.taxItemsID,
c.rname AS regionName
FROM tbTaxBill a INNER JOIN
symCompany b ON a.companyID = b.rid INNER JOIN
symRegion c ON b.regionID = c.rid
WHERE
taxBillDate>=@BeginDate AND taxBillDate<@EndDate AND a.IsLandTax=@IsLandTax AND @Qtype LIKE '%'+@condition+'%'
GO倒数第二行有问题
我在查询分析器中用
exec ReportPayMoneyDetail '2001-01-01','2009-01-01','Y','c.rname','工'
执行结果为空,但是把存储过程中的 @Qtype 换成 c.rname 就可以出来。
高手请帮忙
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货