I need to make a select on a table with a Bit field called 'Submitted' = true and ordered by Int 'OrderNo' desc. But I also need to select the top1 row in that table when 'Submitted' = false and ordered by OrderNo asc.
I need these in the one select with the 1 unsubmitted row as being the first row of the rows returned.
I can do them separately but am running into problems on how to do this in the 1 select.
Any advise, much appreciated.