请教高手,我错在哪了。
@deptid int,
@auxprop int
declare @sql varchar (8000)
set @sql='SELECT isnull(convert(varchar(10),FDate1,120),'''') date1, isnull(convert(varchar(10),FDate2,120),'''') date2,isnull(convert(varchar(10),FDate3,120),'''') date3,
fkinds,fitemnumber,fitemname,convert(numeric(18,2),Fqty) fqtybase,convert(numeric(18,2),FPrice) ftaxprice,
convert(numeric(18,2),FAmt) famttotal,FNumber,FName,isnull(freturnfamt,0) item5,FBILLID,isnull(fpaybillid,'''') fskbillid,isnull(fsettlefamt,0) item6,fdeptid,aa
from #settle '
--exec (@sql)
if @deptid<>0
if @auxprop=0
set @sql=@sql+' where fdeptid ='''+ @deptid+ ''''
else
set @sql=@sql+' where fdeptid ='''+ @deptid+ ''''+ 'and fauxpropid = ''' + @auxprop + ''''
else
if @auxprop=0
set @sql=@sql
else
set @sql=@sql+' where fauxpropid = ''' + @auxprop + ''''
set @sql=@sql
exec(@sql)