Bonjour,

avec la requête suivante j'obtiens 2 jeux de résultat et je ne comprends pas pourquoi :

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
 
WITH [Table_Temp] AS ( 
  	SELECT case when master.dbo.fn_varbintohexstr([Cust_ Menu Roast Header].[timestamp]) is null then '1' else master.dbo.fn_varbintohexstr([Cust_ Menu Roast Header].[timestamp]) end + case when master.dbo.fn_varbintohexstr([Cust_ Menu Roast Line].[timestamp]) is null then '1' else master.dbo.fn_varbintohexstr([Cust_ Menu Roast Line].[timestamp])  END AS [DropDownValue], 
         [No_],
         [Cust_ Menu Roast Header].[Contact No_],
         [Cust_ Menu Roast Header].[Type], 
         [Cust_ Menu Roast Header].Code, 
         [Roast Element], 
         [Cust_ Menu Roast Header].[Grammage Code], 
         [Cust_ Menu Roast Header].[Date Start], 
         [Cust_ Menu Roast Header].[Date End], 
         [Cust_ Menu Roast Header].[Update Order Allowed], 
         [Cust_ Menu Roast Header].[Supplement %], 
         [Cust_ Menu Roast Header].[Cancelation %], 
         [Cust_ Menu Roast Header].[Max Meal Number], 
         [Day of Week], [Element on Menu], 
         [Element on Pre-Order], 
         [Free Element], Sort, 
         [Cust_ Menu Roast Header].[Kitchen Code], 
  		 ROW_NUMBER() OVER(ORDER BY [Cust_ Menu Roast No_],[Roast Element],[Day of Week]) AS 'ROW_NUMBER' 
    FROM [Cust_ Menu Roast Header] 
  	LEFT OUTER JOIN [Cust_ Menu Roast Line] 
  	ON [Cust_ Menu Roast Header].No_ = [Cust_ Menu Roast Line].[Cust_ Menu Roast No_] 
) 
SELECT * FROM [Table_Temp] 
WHERE [contact no_] = 'R02489' and code ='GC9'
resultat 1 :
ROW_NUMBER = 2785

Resultat 2 :
ROW_NUMBER = 2460