![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL查询
雁过留香
这个作者很懒,什么都没留下…
展开
-
财务凭证查询
if object_id('tempdb..#pz') is not null Begin drop table #pz End select * into #pz from ( select a.FDate ,a.FYear,a.FNumber as Fpznum,b.FExplanation , case when CHARINDEX('.',REPLACE(REPLACE(b.F...原创 2019-02-22 15:56:41 · 609 阅读 · 0 评论 -
研发费用查询
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO alter procedure GF_2017研发费用( @FDateStart datetime, @FDateEnd datetime ) as set nocount on --可调节腰靠座椅的研发 if object_id('tempdb..#a') is not nu...原创 2019-02-22 15:57:46 · 518 阅读 · 0 评论 -
插入订单通知单,更新批次调整单日期
插入订单通知单 select b.* from t_bosddtzd a inner join t_bosddtzdentry b on a.FID = b.FID where FBillNo= 'GF3309-109-ME' select a.* from seorder a inner join seorderentry b on a.FinterID = b.FinterID where...原创 2019-03-07 16:07:32 · 375 阅读 · 0 评论 -
重复值查询
--select t1.FName from icbom a --inner join icbomchild b on a.FinterID = b.FinterID --inner join t_icitem t1 on a.FitemID = t1.FitemID --inner join t_icitem t2 on b.FitemID = t2.FitemID --where (t2.FN...原创 2019-03-07 16:09:54 · 123 阅读 · 0 评论 -
更新生产任务单关联数量
select FCommitQty , FAuxCommitQty,* from icmo where FBillNo in ('GF7904-A555K*11') --update icmo set FCommitQty = 0, FAuxCommitQty = 0 --where FBillNo in ('GF7904-A555K*11')原创 2019-03-07 16:10:48 · 395 阅读 · 0 评论