Skip to Content
0
Former Member
Apr 25, 2014 at 07:29 PM

how to accomplish this?

33 Views

I have an stored procedure that give me 7 days date range excluding Sunday. I have this on my table

truck date in qty

truck1 20140424 8:00 1

truck2 20140423 9:00 2

truck3 20140422 8:10 3

truck2 20140421 10:20 4

truck3 20140419 7:00 5

truck1 20140424 5:00 6

truck4 20140424 9:00 7

I have to accomplish this

20140424 20140423 20140422 20140421 20140419

truck in qty in qty in qty in qty in qty

truck1 8:00 1

truck2 9:00 2

truck3 8:10 3

truck2 10:20 4

truck3 7:00 5

truck1 5:00 6

truck4 9:00 7