There are a couple of things that aren't clear:

1.) Are time spans ever overlapping?
2.) Are you seeking only data where an ID has an "urgent" status?
3.)...

Here's what I used to try and get the data:
CREATE TABLE #tblOrders (
    OrderID int NOT NULL PRIMARY KEY,
    JobStatus nvarchar(50) NOT NULL,
    JobType nvarchar(50) NOT NULL,
    BidDate datetime...

Looks like this is what's needed, but the original poster will have to validate and supply his or her own start and end date parameters:
CREATE TABLE #tblOrders (
    OrderID...

You would have to assume that both database engines use the exact same encryption AND decryption algorithms, and yes, you should go ahead and test it pretty thoroughly.   Last thing...

You can also try the following, which will use a parameter for the starting date and just use the run date as the last possible date, so you could choose...

I usually try to help people, but when the situation as described just doesn't make any sense, and the organization is an airline that ought to know better from an...