表里面已经有了datasource, custid, custname, sector , 现在我想用declare cursor 的方式把其他的数据放进去 LMTDIN
直到 CLMTD, 以下是我的program, 各位帮忙看下对吗Declare Cursor Cur_Saleselect * from bdbip2 order by datasource, custname, sectoropen Cur_SaleFetch Next from Cur_Sale into @datasource, @custname, @sector
while @@Fetch_status=0
Begin select @LMTDIN=sum ( unitprice*po_qty) as SalesIN from purorder
where a.keyindate>=@PDATEFr and a.keyindate<=@PDateTo and custid=@custid select @CMTDIN=sum ( unitprice*po_qty) as Salesout from invoice
where month (a.keyindate)=month(@Today) and Year(a.keyindate)=year(@Today) and custid=@Cust
直到 CLMTD, 以下是我的program, 各位帮忙看下对吗Declare Cursor Cur_Saleselect * from bdbip2 order by datasource, custname, sectoropen Cur_SaleFetch Next from Cur_Sale into @datasource, @custname, @sector
while @@Fetch_status=0
Begin select @LMTDIN=sum ( unitprice*po_qty) as SalesIN from purorder
where a.keyindate>=@PDATEFr and a.keyindate<=@PDateTo and custid=@custid select @CMTDIN=sum ( unitprice*po_qty) as Salesout from invoice
where month (a.keyindate)=month(@Today) and Year(a.keyindate)=year(@Today) and custid=@Cust
while @@Fetch_status=0
Beginselect @LMTDIN=sum ( unitprice*po_qty) as SalesIN from purorder
where a.keyindate>=@PDATEFr and a.keyindate<=@PDateTo and custid=@custidselect @CMTDIN=sum ( unitprice*po_qty) as Salesout from invoice
where month (a.keyindate)=month(@Today) and Year(a.keyindate)=year(@Today) and custid=@Cust