1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[CB_EqGreaterILS_STOCK2] @cbAR_Ref varbinary(20),@LS_MvtStock smallint,@LS_LotEpuise smallint,@cbLS_NoSerie varbinary(32) AS
BEGIN
SET NOCOUNT ON;
IF EXISTS(SELECT TOP 1 'A' FROM F_LOTSERIE WHERE cbAR_Ref = @cbAR_Ref AND LS_MvtStock = @LS_MvtStock AND LS_LotEpuise = @LS_LotEpuise AND cbLS_NoSerie >= @cbLS_NoSerie)
SELECT TOP 1 * FROM F_LOTSERIE WHERE cbAR_Ref = @cbAR_Ref AND LS_MvtStock = @LS_MvtStock AND LS_LotEpuise = @LS_LotEpuise AND cbLS_NoSerie >= @cbLS_NoSerie ORDER BY cbAR_Ref,LS_MvtStock,LS_LotEpuise,cbLS_NoSerie,cbMarq;
ELSE
IF EXISTS(SELECT TOP 1 'A' FROM F_LOTSERIE WHERE cbAR_Ref = @cbAR_Ref AND LS_MvtStock = @LS_MvtStock AND LS_LotEpuise > @LS_LotEpuise)
SELECT TOP 1 * FROM F_LOTSERIE WHERE cbAR_Ref = @cbAR_Ref AND LS_MvtStock = @LS_MvtStock AND LS_LotEpuise > @LS_LotEpuise ORDER BY cbAR_Ref,LS_MvtStock,LS_LotEpuise,cbLS_NoSerie,cbMarq;
ELSE
IF EXISTS(SELECT TOP 1 'A' FROM F_LOTSERIE WHERE cbAR_Ref = @cbAR_Ref AND LS_MvtStock > @LS_MvtStock)
SELECT TOP 1 * FROM F_LOTSERIE WHERE cbAR_Ref = @cbAR_Ref AND LS_MvtStock > @LS_MvtStock ORDER BY cbAR_Ref,LS_MvtStock,LS_LotEpuise,cbLS_NoSerie,cbMarq;
ELSE
SELECT TOP 1 * FROM F_LOTSERIE WHERE cbAR_Ref > @cbAR_Ref ORDER BY cbAR_Ref,LS_MvtStock,LS_LotEpuise,cbLS_NoSerie,cbMarq;
END; |
Partager