so for.....

drs.void_date >= DATEADD(day, DATEDIFF(day, 0, CURRENT_TIMESTAMP), -3)
    AND drs.void_date < DATEADD(day, DATEDIFF(day, 0, CURRENT_TIMESTAMP), 0)

will return the records with void _date between 3...

can I have someone explain how on my original script this:

WHEN CAST(drs.void_date AS DATE) = CAST(dateadd(day, -1, getdate()) AS DATE)

differs from this

so I think its just the two parts which end AS real_date, so from below

WHEN CAST(void_date AS DATE) = CAST(dateadd(day, -1, getdate()) AS DATE)
THEN (substring(cast(cast(drs.void_date...

could you tell me where in my script this would need to be done?

I believe the customer we're sending this to the orders only have 1 pickup and 1 stop

can you explain why in:

sPU.actual_departure >= dateadd(mm, datediff(mm, 0, getdate()), 0)

you would write as

sPU.actual_departure >= dateadd(mm, datediff(mm, 0, getdate()), -1)  to get the...

If I'm understanding correctly GetDate() is for the current date and the above would pull anything 1 month before the current date

so I believe this should work

AND sPU.actual_departure > DateAdd(M, -1, GetDate());

so now I'm needing based off our scheduler to send the report out based of the previous month's actual departure

so for February it would be what is below,...

how does it know that sPU and sSO are off of the stop table?

So that appeared to work!! Thank you so much, but I'm not understanding where sPU and sSO and defined?

but from what is listed above how would I display my data on one row so it would match my example?

Basically for every  two stops  there is one...

with what I'm doing with our software, we're a transportation brokerage and with their 'Document Designer' aka form builder using sql, I cannot use CREATE TABLE

sorry about that I will do that in the future.....what was provided was just a small sample of data, I think what you wrote as below works, I just need...

Here is an example on order 0940136