1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date, ,>
-- Description: <Description, ,>
-- =============================================
ALTER FUNCTION [dbo].[fct_get_prix_unitaire]
(
-- Add the parameters for the function here
@CLI_COD AS VARCHAR(7),
@ART_COD AS VARCHAR(16)
)
RETURNS FLOAT
AS
BEGIN
-- Declare the return variable here
DECLARE @PRIX_UNIT AS FLOAT
-- Add the T-SQL statements to compute the return value here
SELECT @PRIX_UNIT = TOP(1) rq_gpao_facture_clients_pos.fdp_pvu_d
FROM rq_gpao_facture_clients_pos LEFT OUTER JOIN rq_gpao_factures_clients ON
rq_gpao_facture_clients_pos.fdb_num = rq_gpao_factures_clients.fdb_num
WHERE (rq_gpao_factures_clients.fdb_fdbndc <> 'C') AND (rq_gpao_facture_clients_pos.art_cod = @ART_COD) AND
(rq_gpao_facture_clients_pos.cli_cod = @CLI_COD)
ORDER BY rq_gpao_facture_clients_pos.fdp_dat_cre DESC
-- Return the result of the function
RETURN @PRIX_UNIT
END |
Partager