Nevermind all...if found my issue.   my "on" conditions were not specific enough in the actual code.    once i fixed that, it worked like a charm!

I'm pulling in sales numbers from a database that is updated every 15 minutes and displayed on a monitor for our salespeople.     The numbers are displayed in a graphical...

Thanks Ed and Sue.  I guess i was thinking there was some type of windows macro (mouse more and click) that will clear out messages like the one I have. ...

Very cool!! Thank you for the link.  I'll study this and see what i can do to set this up. You're awesome!

^^ Good point. I thought about that for other operational reports but for GL reporting, it will work fine.

Thanks

This worked perfect! I didnt realize you can abbreviate the table names for ease of use later. That really helps!

This got me exactly what i needed though!...

Luis Cazares (2/20/2015)

---

Does this return any rows?

select *

from orders o

JOIN stop first_stop on o.first_stop_id = first_stop.id

JOIN sales s ON o.id = s.reference

WHERE s.dis IN( 'a', 'b', 'c')

AND o.status =...

discounts is basically coming back null.

Luis Cazares (2/19/2015)

---

s is an alias for the resultset from the apply. It can be anything but I prefer it to be something that could be significant. On the ISNULL...

sqlnoob2015 (2/19/2015)

---

Luis Cazares (2/19/2015)

---

Do you have anything else in the code?

Did you run the exact same code I posted?

Note that I changed the JOIN to an APPLY and the column...

Luis Cazares (2/19/2015)

---

Do you have anything else in the code?

Did you run the exact same code I posted?

Note that I changed the JOIN to an APPLY and the column expression...

Luis Cazares (2/19/2015)

---

What about this?

select

first_stop.actual_departure 'Start'

, last_stop.actual_departure 'End'

, last_stop.city_name 'End city'

, last_stop.state 'End state'

, last_stop.zip_code 'End zip'

, first_stop.city_name 'Start city'

, first_stop.state 'Start state'

, first_stop.zip_code 'Start zip'

, datediff (day, last_stop.actual_departure,...

Never Null.