[CIMPRODUCT - Fonctions Scalaires] Fonctions scalaires #cimproduct #sql #fonctions_scalaires

CIMPRODUCT - F_VerifClotureMetaOF.sql

USE [Cimprod_Mithieux]
GO

/****** Object:  UserDefinedFunction [dbo].[F_VerifClotureOF]    Script Date: 09/02/2022 11:46:41 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE FUNCTION [dbo].[F_VerifClotureMetaOF] (
  @IdMetaOF int
)
RETURNS bit
BEGIN
  DECLARE @Result bit
  SELECT @Result = MIN(CAST([OF].Cloture AS int)) FROM [OF] WHERE [OF].IdMetaOF = @IdMetaOF GROUP BY [OF].IdMetaOF
  RETURN ISNULL(@Result, 0)
END
GO

CIMPRODUCT - F_VerifClotureOF.sql

USE [Cimprod_Mithieux]
GO

/****** Object:  UserDefinedFunction [dbo].[F_VerifClotureOF]    Script Date: 09/02/2022 12:02:08 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE FUNCTION [dbo].[F_VerifClotureOF] (
  @IdOF int
)
RETURNS bit
BEGIN
  DECLARE @Result bit
  SELECT @Result = MIN(CAST(OFOperation.Cloture AS int)) FROM OFOperation WHERE OFOperation.IdOF = @IdOF GROUP BY OFOperation.IdOF
  RETURN ISNULL(@Result, 0)
END
GO