Discussion :

[meri_mima]

bonjour
j'ai un message d'erreur qunad j'ajoute order by
exemple

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
select distinct id 
        ,nom 
        ,prenom 
from table1 , table2 
where table2 table2 id=table1.id 
order by nom

merci pour votre aide

[mikedavem]

Bonjour,

quel est votre message d'erreur ? (colonne nom ambigue ... ??)

postez la DDL de vos tables ...

++

[meri_mima]

order by file must appear in the select list if select distinct is specified

[meri_mima]

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
33
34
35
36
37
38
39
40
ALTER PROCEDURE [dbo].[usp_Select_Demande]
(
@strPiece AS NVARCHAR(50),
@strDate AS NVARCHAR(50),
@strIntitule AS NVARCHAR(50),--fournisseur
@strDemandeur AS NVARCHAR(50),
@strImputation AS NVARCHAR(50),--Site
@strEntite AS NVARCHAR(50)='' --Entite
)
AS
BEGIN
-- Insert statements for procedure here
    SELECT DISTINCT 
top (select top 1 P_Len_Aff from dbo.Parametres)
 
IsNull(DE.Do_Piece,'') AS Do_Piece, 
                         IsNull(DE.Do_Demandeur,'') AS Do_Demandeur
,IsNull(DE.T_IdContact,'') AS Idcontact,
                         IsNull(DE.Do_Date,'') AS Do_Date,
                         IsNull(DE.Do_Projet,'') AS Do_Projet,
                         IsNull(CT.T_Tier,'') AS T_Tier,
                         IsNull(CT.T_intitule,'') AS T_intitule,
                         IsNull(CT.T_Tel,'') AS T_Tel,
                         IsNull(CT.T_Faxe,'') AS T_Faxe,
                         IsNull(DE.Do_Imputation,'') AS Do_Imputation,
                         IsNull(DE.Statut,'') AS Statut
 
    FROM dbo.Compte_Tier AS CT INNER JOIN
 
                                 dbo.DocEntete AS DE ON CT.T_Tier = DE.T_Tier INNER JOIN
                                 dbo.DocLigne AS DL ON DE.Do_Piece = DL.Do_Piece
 
    WHERE (DE.Do_Piece=@strPiece or @strPiece='')
     and(DE.Do_Date=@strDate or @strDate='')
     and(CT.T_intitule like '%'+@strIntitule+'%' or @strIntitule='')
     and(DE.Do_Demandeur like '%'+@strDemandeur+'%' or @strDemandeur='')
     and(DE.Do_Imputation like '%'+@strImputation+'%' or @strImputation='')
        and (substring(DE.Do_Piece,13,len(DE.Do_Piece)) like '%'+@strEntite+'%' or @strEntite ='')
order by DE.Do_Piece desc
END