sumeing的专栏

       如何通过金蝶分析一段时间（主要）各供应商供货数量和金额占（主要）供应商总数量和总金额的比例。       select distinct(Select sum(fauxqty) from ICStockBill v1 INNER JOIN ICStockBillEntry u1 ON     v1.FInterID = u1.FInterID   AND u1.FInterID 0 INNER JOIN t_Supplier t4 ON     v1.FSupplyID = t4.FItemI

<br />转自：救火论坛<br /><br />CREATE PROCEDURE [MyContractSale] <br />@Bdate as datetime,<br />@Edate as datetime,<br />@CustName as nvarchar(100)<br />AS<br />功能:销售合同执行汇总表,一览方式查询<br />制作:救火<br />日期:2009-07-23<br />修改:<br />版本:0.0<br />set nocount off<br />sele

<br /> <br /><br />SELECT t_Currency3.FScale AS FCurrencyID_Decimal,t_currency4.FScale AS FReceiveCyID_Decimal,t_currency5.FScale AS FSettleCyID_Decimal,t_RP_NewReceiveBill.FMulCy,t_RP_NewReceiveBill.FNumber,t_RP_NewReceiveBill.FDate,<br />t_RP_NewReceiveB

<br /> <br /><br />CREATE PROCEDURE [FuRuiBuy]<br />@Bdate as datetime,<br />@Edate as datetime,<br />@SuppName as nvarchar(100), --客户名称<br />@EmpName as nvarchar(100), --业务员<br />@ItemName as nvarchar(100), -- 商品名称<br />@ZhangTao as nvarchar(100), --帐套0<b

<br /><br />Update t_subsys set  Fused = -1 ,  FPeriodSynch = 0 ,  FCheckout = 0 where Fsubsysid = 5 and Fyear= 2009 and Fperiod = 12;<br />Update t_RP_SystemProfile Set FValue = '12' Where FCategory = 'ARP' And FKey = 'FARCurPeriod';<br />Update t_RP_Syst

<br /> <br />/* 向八张出入库老单据体中插入/"销售合约'/"这个字段FEntryCode, 销售合约是核算项目，类别是３００３ */ <br />Insert Into ICTemplateEntry(FID,FCtlIndex,FCtlOrder,FHeadCaption,FHeadCaption_CHT,FHeadCaption_EN,FCtlType,FLookUpCls,FNeedSave,FValueType,FSaveValue,FFieldName,FWidth,FEnable

create trigger [poorder_insert_01] on [dbo].[poorder]<br />for insert<br />as <br />declare @poorder_interid int <br />select @poorder_interid=finterid from inserted<br />if IF EXISTS ( SELECT 1 FROM poorder p1 inner join poorderentry p2 on <br />p1.finter

BillTypeIDFNameFTypeIDFTemplateIDFDataSqlFTableName1外购入库158SELECT * FROM vwStockBills WHERE FTranType=1ICStockBill2产品入库255SELECT * FROM vwStockBills WHERE FTranType=2ICStockBill5委外加工入库556SELECT * FROM vwStockBills WHERE FTranType=5ICStockBill7其他入库1057SELEC

BillTypeIDFNameFTypeIDFTemplateIDFDataSqlFTableName1外购入库158SELECT * FROM vwStockBills WHERE FTranType=1ICStockBill2产品入库255SELECT * FROM vwStockBills WHERE FTranType=2ICStockBill5委外加工入库556SELECT * FROM vwStockBills WHERE FTranType=5ICStockBill7其他入库1057SELEC

BillTypeIDFNameFTypeIDFTemplateIDFDataSqlFTableName1外购入库158SELECT * FROM vwStockBills WHERE FTranType=1ICStockBill2产品入库255SELECT * FROM vwStockBills WHERE FTranType=2ICStockBill5委外加工入库556SELECT * FROM vwStockBills WHERE FTranType=5ICStockBill7其他入库1057SELEC

<br /> <br /> <br />CREATE PROCEDURE [MyContractReport2] AS<br />/**合同跟踪表**/<br />set nocount on<br />Create Table #t_Phase(<br />   FPhaseName varchar(355), <br />   FTypeID int not null default(0)) <br />Insert into #t_Phase values('采购订单',1) <br />Insert

select t.* from t_RP_ARPBill tINNER JOIN t_rp_arpbillEntry u ON t.FBillID=u.FBillID

<br />  此问题接上一个日志，根据BOM资料，按照采购件物料查找到所有用到此物料的产成品，这里又建立个存储过程和一张表，下面存储过程是通过游标取出所有产成品的采购件，并插入到这个实体表，因为数据量比较大，所以在数据库建立了作业（设置的在半夜执行），先删除实体表数据，并重新执行存储过程插入新数据。<br />set ANSI_NULLS ON<br />set QUOTED_IDENTIFIER ON<br />go create procedure [dbo].[aaa_BOM]as---------

      如何通过金蝶分析一年内各周（主要）各供应商供货数量和金额占（主要）供应商总数量和总金额的比例。   set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoCREATE PROCEDURE [dbo].[Fls_StockIN] @flag intASBEGIN set datefirst 5 select year(a.fdate) 年,datepart(week,a.fdate) 周,c.fshortname 供应商,sum(fqty) 数量,sum(famou

<br />  根据BOM多级展开查找产品采购件，另外在EXCEL中做了一个宏来取数（需要修改连接数据库内容），可多次输入成品代码分别取出数据并保存<br />set ANSI_NULLS ON<br />set QUOTED_IDENTIFIER ON<br />go<br /> <br />create PROCEDURE [dbo].[aaa_BomExpand]<br />(<br />@FNumber varchar(100),<br />@ExpandLevel int=50, ----展开级数

<br /> <br />查科目IT内码<br />select * from t_account <br />where fname like '%客户%'<br /> <br /><br />单据科目与凭证科目不一致<br />SELECT *<br />FROM t_RP_ARPBill<br />WHERE (FNumber LIKE 'QTYs%')<br />修改FAcountID<br /> <br /><br />收款单列表<br />select * from t_RP_NewReceiv

<br /> <br /><br />SELECT  distinct * from t_fagroup where fid<>0  order by fnumber <br />SELECT  *   FROM t_FALocation WHERE FID <> 0  ORDER BY FNumber

<br />SELECT *<br />FROM t_SystemProfile<br />WHERE (FCategory = 'GL')

<br /> <br />原因为K3结算查询代码多了个<br /> <br />select a.FExchangeRateType,b.FID,a.FClassTypeID,a.FCurrencyID,a.FCustomer,a.FDepartment ,a.FEmployee,a.FItemClassID,a.FBillID FInterID,0 FPre,<br />0 FIsInit,b.FK3Import,b.FStatus,b.FCheckType, 0 FInvoiceID,a.FBillID

<br /> <br /><br />DELETE FROM ICListTemplate WHERE FID=70001;<br />DELETE FROM ICChatBillTitle WHERE FTypeID = 70001;<br />DELETE FROM t_ObjectAccessType WHERE FObjectType=4100 AND FObjectID =70001;<br />DELETE FROM t_ObjectType WHERE FObjectType=4100 AND

<br />科目余额表代码<br /><br />/**公司名称代码开始**/<br />Select t.* Into #AcctBal2569457n <br />From (<br />    Select 0 FBalanceTotal,a.FAccountID,a.FNumber ,<br />    convert(varchar(800),a.FName) FName,a.FLevel,a.FDC,a.FDetail,<br />    a.FParentID,a.FRootID,Isnull

<br />常用SQL系统表  1、系统表 t_tabledescription<br />2、字段表 t_fielddescription<br />3、基础资料表（版本：10.3） t_item 其中fitemclassid值表示<br />      1-客户；2-部门；3-职员；4-商品；5-仓位；7-单位；8-供应商。<br />部门 t_department;职员 t_emp;商品 t_icitem;仓库 t_stock;单位 t_measureunit<br />4、客户资料表 t_org