This query selects all the calls in dispatch table. For each Call, it looks in the all_paths_serv_call table and selects all the calls in this table that has the same serial number as the call from dispatch. It then links to the parts table and
pulls all the parts used on the call. This is all working fine, except when it pulls the calls from serve_call, I only want it to get the most recent 5 calls in the table based on all_paths_serv_call.CALL_DATE_SCA.
Any help would be appreciated. I saw something about using "with rownumbersadded" but wasnt sure where or how to insert it.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.