那没有办法一条sql处理，看懂自己改进
ALTER PROCEDURE [dbo].[抛转主计划]
@订单编号 nvarchar(30)
AS
BEGIN
declare @d1 as date;
declare @d2 as date;
declare @d3 as date;
select @d1=MAX(工序承诺期) from [dbo].[SC_生产工piao明细] where [车间]= '木工车间' and ISNULL([非计划工序],'') = 0 and 订单编号=@订单编号 and 订单_结案否 = 'N'
select @d2=MAX(工序承诺期) from [dbo].[SC_生产工piao明细] where [车间]= '底漆车间' and ISNULL([非计划工序],'') = 0 and 订单编号=@订单编号 and 订单_结案否 = 'N'
select @d3=MAX(工序承诺期) from [dbo].[SC_生产工piao明细] where [车间]= '打磨车间' and ISNULL([非计划工序],'') = 0 and 订单编号=@订单编号 and 订单_结案否 = 'N'
if @d2 is null
begin
set @d2=@d3
end
if @d1 is null
begin
set @d1=@d2
end
UPDATE [dbo].[PMC_主计划]
SET [木工车间_承诺期] =@d1,[底漆车间_承诺期] = @d2
End
[此贴子已经被作者于2020/10/13 15:50:58编辑过]
加好友 
发短信
Post By：2020/10/13 14:52:00 [只看该作者]
