Create Table ##T_Order (
Cust_Name Varchar(50), --客户名称
Invoice_Num VarChar(80), --发票号码
Amount Numeric(18,2), --发票金额
ShipDate Varchar(40), --出货日期
PayDate Varchar(40), --应付款日期
CPayDate Varchar(40), --客户确认付款日期
ActAmount Numeric(18,2), --实际付款金额
RMBAmount Numeric(18,2), --折合人民币
Currency_rate Numeric(18,4), --汇率
Fee Numeric(18,2), --手续费
BalaAmount Numeric(18,2), --余额
ExpiredDays Smallint, --逾期天数
Re Varchar(150), --备注
)
Insert Into ##T_Order(Cust_Name,Amount,ShipDate,PayDate,CPayDate,ActAmount,RMBAmount,Fee,BalaAmount,ExpiredDays,Re,Invoice_Num)
select Distinct Cust_Name,Amount,ShipDate,PayDate,CPayDate,ActAmount,ActAmount * Currency_rate As RMBAmount,Fee,BalaAmount,ExpiredDays,Re,Invoice_Num from Test1
Declare OrderAnaly_Cursor1 CURSOR FOR
Select id,CommCode,CommName from commcoded where commtable='帐号' Open OrderAnaly_Cursor1
Fetch Next From OrderAnaly_Cursor1 Into @ID,@Acc_ID, @Acc_Name
While @@FETCH_STATUS=0
Begin
exec ('Alter Table ##T_Order Add '+@Acc_Name +' [Numeric](18,2)')
-- print 'The Next result is '+Str(@id)+ ' '+@Acc_Name
Fetch Next From OrderAnaly_Cursor1 Into @ID,@Acc_ID, @Acc_Name EndSelect * from ##T_order
Drop Table ##T_Order
Close OrderAnaly_Cursor1
DealLocate OrderAnaly_Cursor1
我想得到2005-08-01,2005-08-02,2005-08-03,...2005-08-29,2005-08-30,2005-08-31
而且要把得到的每一天都写入数据库中。还有一个月28,29,30,31天的该怎么办?
最好是用sql语句来写!谢谢了!