1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
declare @montant varchar(30)
SELECT @montant=dbo.ufn_GetMantant(Do_Piece) from DocEntete
SELECT DISTINCT top
dbo.ufn_GetMantant(Do_Piece)
,IsNull(Do_Piece,'') AS Do_Piece
,IsNull(Do_Date,'') AS Do_Date
,IsNull(Do_AcceptePar,'') AS Do_AcceptePar
,IsNull(T_IdContact,'') AS Idcontact
,IsNull(Date_Livraison,'') AS Date_Livraison
,IsNull(Libelle,'') AS libelle_Service
,IsNull(T_intitule,'') AS Intitule
,IsNull(Do_Demandeur,'') AS Do_Demandeur
,Statut
FROM DocEntete ,fonction fonc ,Compte_Tier com |
Partager