How to add a cross apply to a BAQ

[knash (Ken Nash)]

This can be done in a CTE as well.

check out the baq in this post.

SHOPLOAD - Who out there uses it, and how?

Thanks for the assist. ShopLoadRG.baq (87.1 KB) Took what you had and did a CTE to extract the hours and date from those strings. Attaching the BAQ to show the additions. I didn’t refactor the query but you get the idea. Now I am going to create a summary layer, but that should be easy to do.