Timeline for Project management query for various organizational units
Current License: CC BY-SA 4.0
31 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 10, 2020 at 13:24 | history | edited | CommunityBot |
Commonmark migration
|
|
| Aug 23, 2018 at 0:47 | history | edited | aduguid | CC BY-SA 4.0 |
deleted 91 characters in body
|
| Aug 23, 2018 at 0:46 | history | rollback | aduguid |
Rollback to Revision 15
|
|
| Aug 23, 2018 at 0:35 | vote | accept | Sa Ra Fin Bas | ||
| Aug 23, 2018 at 0:35 | comment | added | Sa Ra Fin Bas | Now it's working as expected, thank you very much I really appreciate what you did, I have learned very important things from your code, I will accept the answer because it helped me and improved my SQL knowledge | |
| Aug 23, 2018 at 0:22 | comment | added | aduguid |
Since I wrapped the CASE expression in the SUM, we don't need the other columns in the GROUP BY
|
|
| Aug 23, 2018 at 0:22 | history | edited | aduguid | CC BY-SA 4.0 |
deleted 91 characters in body
|
| Aug 23, 2018 at 0:21 | comment | added | aduguid | I just noticed the group by is a bit off, I'll update it now | |
| Aug 23, 2018 at 0:20 | comment | added | Sa Ra Fin Bas | It only sums Expenses with same date, so it will give me wrong value and repeat the project imgur.com/3DjmQda | |
| S Aug 23, 2018 at 0:19 | history | suggested | Sa Ra Fin Bas | CC BY-SA 4.0 |
Insert Image
|
| Aug 23, 2018 at 0:16 | review | Suggested edits | |||
| S Aug 23, 2018 at 0:19 | |||||
| Aug 22, 2018 at 23:25 | comment | added | aduguid |
I also had to wrap the CASE expression with SUM for the grouping
|
|
| Aug 22, 2018 at 23:24 | history | edited | aduguid | CC BY-SA 4.0 |
deleted 503 characters in body
|
| S Aug 22, 2018 at 23:24 | history | suggested | Sa Ra Fin Bas | CC BY-SA 4.0 |
Correct GROUP BY clause
|
| Aug 22, 2018 at 23:15 | comment | added | Sa Ra Fin Bas | Thanks, corrected it and will give it some tests and back later to tell you if it's what I'm looking for. | |
| Aug 22, 2018 at 23:12 | review | Suggested edits | |||
| S Aug 22, 2018 at 23:24 | |||||
| Aug 22, 2018 at 21:21 | comment | added | aduguid | I'll update my answer when I get to the office. My apologies, I don't have an instance of Firebird on my machine to test the syntax. | |
| Aug 22, 2018 at 19:11 | comment | added | Sa Ra Fin Bas |
Thanks, I spend long time trying to make it works but it's not working I get this error Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause).
|
|
| Aug 22, 2018 at 12:59 | history | edited | aduguid | CC BY-SA 4.0 |
deleted 168 characters in body
|
| Aug 22, 2018 at 8:07 | history | edited | aduguid | CC BY-SA 4.0 |
deleted 1 character in body
|
| Aug 22, 2018 at 6:53 | history | edited | aduguid | CC BY-SA 4.0 |
added 1 character in body
|
| Aug 22, 2018 at 6:48 | history | edited | aduguid | CC BY-SA 4.0 |
deleted 62 characters in body
|
| Aug 22, 2018 at 6:42 | history | edited | aduguid | CC BY-SA 4.0 |
deleted 62 characters in body
|
| Aug 22, 2018 at 6:35 | history | edited | aduguid | CC BY-SA 4.0 |
deleted 62 characters in body
|
| Aug 22, 2018 at 6:03 | history | edited | aduguid | CC BY-SA 4.0 |
deleted 2 characters in body
|
| Aug 22, 2018 at 5:46 | history | edited | aduguid | CC BY-SA 4.0 |
added 133 characters in body
|
| Aug 22, 2018 at 5:38 | history | edited | aduguid | CC BY-SA 4.0 |
deleted 308 characters in body
|
| Aug 22, 2018 at 5:32 | history | edited | aduguid | CC BY-SA 4.0 |
deleted 1036 characters in body
|
| Aug 22, 2018 at 5:15 | history | edited | aduguid | CC BY-SA 4.0 |
added 214 characters in body
|
| Aug 22, 2018 at 4:55 | history | edited | aduguid | CC BY-SA 4.0 |
added 4 characters in body
|
| Aug 22, 2018 at 4:48 | history | answered | aduguid | CC BY-SA 4.0 |