Formatting was lost, so retrying:
ORDER_NO TASK_NAME CREATED_DATE COMPLETE_DATE DIFFERENCE
2017-25420 Pricing - Banana 04/05/2017 06/12/2017 68
2017-25420 Pricing - Banana 04/07/2017 06/12/2017 66
2017-25420 Pricing - Carrots 07/01/2017 07/12/2017 11
2017-25420 Pricing - Carrots 07/11/2017 07/12/2017 01
I haven't done a crosstab query for a long while, but I think that is what I kinda need. The query needs to show all of the above columns, and the closest date difference for each of the above groups. The order numbers do change. Do I have to concatenate the first three columns, in order to pick the best difference? If possible, I think a simple SQL solution would work, but I can't think of any right now.
Idea result would be:
2017-25420 Pricing - Banana 04/07/2017 06/12/2017 66
2017-25420 Pricing - Carrots 07/11/2017 07/12/2017 01
Thanks for any help,
Mark B.
__._,_.___
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar