文章分类 -  其它

摘要：set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgo/*--exec up_进销存汇总_export '%','2011-06-25','2011-07-24','','',''--执行完成后汇总数据存储在表temp_jxc_export中*/CREATE PROCEDURE [dbo].[up_进销存汇总_export] @arg_isforeign varchar(10),@arg_dtbe datetime ,@arg_dten datetime,@arg_w 阅读全文

摘要：declare @inventb_id_t varchar(40),@part_id_t varchar(40)declare cur_delete_data cursor forselect inventb_id, part_idfrom f_invent_bill_items_7月份未核对上的明细备份 f_items_7where f_items_7.part_id in (select part_idfrom f_partwhere partacctype_id = 'Z003')open cur_delete_datafetch cur_delete_data into 阅读全文

摘要：--------------------------更新委外加工单DECLARE @ARG_PARTID VARCHAR(40),@ARG_EXTRAUNITID VARCHAR(40),@ARG_FACTPRICE DECIMAL(18,4),@ARG_FACTPRICE_UN DECIMAL(18,4),@arg_count decimal(10,2)select @arg_count = 1DECLARE CUR_FACTPRICE CURSOR FORSELECT PART_ID , EXTRAUNIT_ID , FACTPRICE_PRICETAX ,factprice_priceF 阅读全文

摘要：--------------------------更新委外加工单DECLARE @ARG_PARTID VARCHAR(40),@ARG_EXTRAUNITID VARCHAR(40),@ARG_FACTPRICE DECIMAL(18,4),@ARG_FACTPRICE_UN DECIMAL(18,4),@arg_count decimal(10,2)select @arg_count = 1DECLARE CUR_FACTPRICE CURSOR FORSELECT PART_ID , EXTRAUNIT_ID , FACTPRICE_PRICETAX ,factprice_priceF 阅读全文

摘要：DECLARE @ARG_PARTID VARCHAR(40),@ARG_EXTRAUNITID VARCHAR(40),@ARG_FACTPRICE DECIMAL(18,4),@ARG_FACTPRICE_UN DECIMAL(18,4)DECLARE CUR_FACTPRICE CURSOR FORSELECT PART_ID , EXTRAUNIT_ID , FACTPRICE_PRICETAX ,factprice_priceFROM F_FACTPRICEWHERE FACTPRICE_STATUS = 'E' ANDfactprice_type = '加工 阅读全文