Timeline for Get ticket sales and reservations grouped by time slot
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 5, 2013 at 21:23 | comment | added | Aaron Bertrand | @Kyle I did look at the screen shots of your sample data (which aren't entirely helpful). Unfortunately the sample data doesn't seem to line up with your expected results. Can you explain to me, given the data shown, how you arrived at Neptune/29/20/9? Or why your screen shots only contain Mars and Saturn, but neither of those missions are in your desired results? Or can you adjust your desired results so that they match the screen shots? I know it's easy for you to see what result you want, but do you see how hard it is for us to see it without complete information? | |
| Feb 5, 2013 at 20:36 | comment | added | Kyle Supe | sure thing, sorry to leave you in the dark, didn't have much time when replying earlier. Your Statement Results is what your statement produces. I didn't need to sum the lngsold column however, so I changed the statement slightly and basically got the same results I had earlier, which was summing the entire lngquantity column My Statement. Have you by chance seen my edits to my original post? I posted the relevant data from each table separately. Thanks for all your help in this and let me know what other info you need! | |
| Feb 5, 2013 at 13:50 | comment | added | Aaron Bertrand | @Kyle Can you explain how I am "quite close" instead of sending me on an expedition? Show me some rows, what my query produces, and what my query should produce. I'm not going to cycle through refactoring my query repeatedly trying to match your results if I don't have more information. | |
| Feb 5, 2013 at 13:14 | comment | added | Kyle Supe | Aaron, you are quite close to what I am looking for, can you look at my edits and see if that helps you at all? | |
| Feb 4, 2013 at 20:16 | history | edited | Aaron Bertrand | CC BY-SA 3.0 |
deleted 24 characters in body
|
| Feb 4, 2013 at 20:10 | history | answered | Aaron Bertrand | CC BY-SA 3.0 |
