SQL查询
雁过留香
这个作者很懒,什么都没留下…
展开
-
财务凭证查询
if object_id('tempdb..#pz') is not null Begin drop table #pzEnd 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 · 644 阅读 · 0 评论 -
研发费用查询
SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOalter procedure GF_2017研发费用( @FDateStart datetime, @FDateEnd datetime )asset nocount on--可调节腰靠座椅的研发if object_id('tempdb..#a') is not nu...原创 2019-02-22 15:57:46 · 550 阅读 · 0 评论 -
插入订单通知单,更新批次调整单日期
插入订单通知单select b.* from t_bosddtzd ainner join t_bosddtzdentry b on a.FID = b.FIDwhere FBillNo= 'GF3309-109-ME'select a.* from seorder ainner join seorderentry b on a.FinterID = b.FinterIDwhere...原创 2019-03-07 16:07:32 · 396 阅读 · 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 · 136 阅读 · 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 · 413 阅读 · 0 评论