why am i getting the error message when both ORDER BY items appear in the SELECT query?
Query
SELECT DISTINCT
B.CreatedDate,
BI.DateFrom,
CONVERT(VARCHAR(8),BI.DateFrom ,3) as FFromDate,
CAST(FLOOR( CAST( BI.DateFrom AS FLOAT ) ) AS DATETIME) as FromDate,
CONVERT(VARCHAR(8),B.CreatedDate ,3) as FBookingDate,
CAST(FLOOR( CAST( B.CreatedDate AS FLOAT ) ) AS DATETIME) as BookingDate,
P.BookingRef,
P.PaymentTypeCode,
(C.Forename + CASE
View Complete Post