#DateForumTypeThreadPost
818 Feb 2016 @ 07:30 PSTDatabaseReplyHelp with SQL for reporting month totalsPerfect!  Thank you so much for your help!  You are a lifesaver!  I really appreciate all of your effort!  
717 Feb 2016 @ 03:25 PSTDatabaseReplyHelp with SQL for reporting month totalsThanks for hanging in there with me!   Now, I'm getting this error: GROUP BY and WITH BY clauses may not contain aggregate functions.   By the way, I changed "mth" to &quo...
617 Feb 2016 @ 02:49 PSTDatabaseReplyHelp with SQL for reporting month totalsI really hate to post this, but I'm getting invalid format string.  Just curious, even if it's formatted correctly, will that first line TRIM(mon (FORMAT 'mmmm')), st...
517 Feb 2016 @ 02:02 PSTDatabaseReplyHelp with SQL for reporting month totalsThanks again.  There is one last problem and then I won't bother you anymore.  The SELECT TRIM(DATE (FORMAT 'mmmm')), is selecting the current date, not the reportin...
417 Feb 2016 @ 12:31 PSTDatabaseReplyHelp with SQL for reporting month totalsThanks again!  See my SQL and output below.  The WHERE statement is from November-January, but it's still only pulling Feb.  I'm positive I have data for the other months. &n...
317 Feb 2016 @ 08:29 PSTDatabaseReplyHelp with SQL for reporting month totalsThanks again!  We're getting close.  When I ran the first solution with the TRIM modification, I'm getting results only for February.  I would like to see multiple months lis...
217 Feb 2016 @ 07:47 PSTDatabaseReplyHelp with SQL for reporting month totalsThank you very much for your reply!  I'm getting an error on TO_CHAR.  It says it's invalid.  Any suggestions?
116 Feb 2016 @ 07:05 PSTDatabaseTopicHelp with SQL for reporting month totalsPlease forgive me if this is a basic question, but I have found myself responsible for creating SQL reports which is not my forte.  Any help will be greatly appreciated! I have current SQL as...