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' |
Partager