ALTER PROC [dbo].[proc_XSth]
  @GSCODE varchar(20)='A002',
 @where varchar(6000)='1=1'
as
 declare @sqlcmd varchar(8000)
if @where='1=1' set @where = 'year(ckdate)=year(getdate()) and month(ckdate)=month(getdate())'
  set @sqlcmd ='
  select * from (
select WRITEDATE,ckdate,GUESTNAME,paydate,CKPAPER,PCODE,PNAME,PSIZE,PFACTORY,CKAMOUNT,XSPRICE,销售总金额=CKAMOUNT*XSPRICE,TXSPRICE,实售总金额=CKAMOUNT*TXSPRICE,COSTPRICE,  TCOSTPRICE,   KCPOSI, KCDEPOT, KCAMOUNT,  OPERATOR, PAYTYPE
from [dbo].[v_pjck] where ckamount<0  AND GSCODE=''A002'' AND '+@where+'
union all
select '''','''','''','''','''','''','''','''',''合计：'',sum(CKAMOUNT),''0'' , sum(CKAMOUNT*XSPRICE),           ''0'', sum(CKAMOUNT*tXSPRICE),   sum(COSTPRICE),SUM(TCOSTPRICE),'''' ,''''  ,sum(KCAMOUNT), '''',    ''''
from [dbo].[v_pjck] where GSCODE=''A002'' AND '+@where+') t
'

 print (@sqlcmd)
 exec (@sqlcmd)
 


    select *  from (
 select ckdate,a.ckpaper,guestname,operator,incharge,paytype,paydate,fptype,a.fhmode,pcode,pname,psize,pfactory,ckamount,COSTPRICE,TCOSTPRICE,xsprice,sumxsprice=ckamount*xsprice*(100-yhl)/100,txsprice,sumtxsprice=ckamount*txsprice*(100-yhl)/100,CKAMOUNT*costprice,CKAMOUNT*tcostprice,xsml=ckamount*(xsprice*(100-yhl)/100*((100-fppoint)/100)-costprice),txsml=ckamount*(txsprice*(100-yhl)/100*((100-fppoint)/100)-costprice),kcdepot,kcposi,pjid,b.writedate
 from pj_ckls a left join pj_cklssub b on a.ckpaper=b.ckpaper where A.gscode='A001' AND guestname LIKE '%开思%' and year(ckdate)=year(getdate()) and month(ckdate)=month(getdate())
 union all
 select '','','','','','','','','','','','','合计：',sum(ckamount),sum(ckamount*COSTPRICE),sum(ckamount*TCOSTPRICE),'0',sum(ckamount*xsprice*(100-yhl)/100),'0',sum(ckamount*txsprice*(100-yhl)/100),'0','0',sum(ckamount*(xsprice*(100-yhl)/100*((100-fppoint)/100)-costprice)),sum(ckamount*(txsprice*(100-yhl)/100*((100-fppoint)/100)-costprice)),'','','',''
 from pj_ckls a left join pj_cklssub b on a.ckpaper=b.ckpaper where A.gscode='A001' AND guestname LIKE '%开思%'and year(ckdate)=year(getdate()) and month(ckdate)=month(getdate())) as t
   
消息 8155，级别 16，状态 2，第 7 行
没有为 't' 的列 21 指定任何列名称。
消息 8155，级别 16，状态 2，第 7 行
没有为 't' 的列 22 指定任何列名称。