#DateForumTypeThreadPost
2213 Jun 2016 @ 12:04 PDTDatabaseTopicFiltering records with SQLI have a parameter in a report (Report Builder 3.0) called REPORT_FILTER.  This parameter has 4 available values.  The labels are (1) Home Group, (2) Home Branch, (3) Other Group, an...
2129 Mar 2016 @ 01:07 PDTDatabaseReplyCreate list of dates Thank you.  That worked for me.  I appreciate the help
2029 Mar 2016 @ 08:01 PDTDatabaseTopicCreate list of dates select calendar_date as DATEO from sys_calendar.CALENDAR where calendar_date between ?  and cast(? as date)+31 order by calendar_date I inherited a report with a 2 date prompts. ...
1915 Feb 2016 @ 12:08 PSTDatabaseReplyExpression for the last day of the month based on Accounting PeriodSorry...............I looked at the report again and there is a year prompt.  The user will select either 2014, 2015, 2016, etc.
1815 Feb 2016 @ 11:54 PSTDatabaseReplyExpression for the last day of the month based on Accounting PeriodThe report is in Report Builder.  The report will calculate these dates and the dates will be used in Teradata SQL to return the results.  The fiscal year changes August 1st and the accou...
1715 Feb 2016 @ 07:28 PSTDatabaseTopicExpression for the last day of the month based on Accounting Period=Year(DateAdd("m", -5, DateValue(Parameters!PD2.Value & "/01/" & Parameters!FY.Value))) & "-" & iif(Month(DateAdd("m", -5, DateValue(Paramete...
1603 Feb 2016 @ 10:50 PSTDatabaseReplycast date between 2 different data typesselect cast (cast (jsdate as Char (8)) as date format 'yyyymmdd') as Date_Col, jsdate, jsn, junit, jmyear, jmake, jmodel, jseries, jbuyid from veh_mgmt_as400.cs087p wh...
1503 Feb 2016 @ 09:47 PSTDatabaseTopicSelect Failed 2666 Invalid date suppliedSELECT 'D' || A.ZARF_ECARS_1 || A.legacy_branch_rented as Transmittal_Number, A.ADDRESS1 as Address, A.CITY as CITY1, A.STATE as STATE1, A.POSTAL as ZIP, A.ITEM as Debtor_Refere...
1403 Feb 2016 @ 06:39 PSTDatabaseTopiccast date between 2 different data typesI want to add a selection criteria to my SQL.  The user will select a 'from' and 'to' date, e.g., 11/1/2015 and 12/31/2015.  The date column (jsdate) in the table is ...
1328 Oct 2015 @ 12:50 PDTDatabaseTopicDuplicate records with a UNIONI have a query with a UNION.  I was trying to combine 2 records into 1.  The top half gets records from 1 set of tables and the bottom half gets records from a differen set of tables.&nbs...
1228 Oct 2015 @ 07:00 PDTDatabaseReplySelect Failed [2616] Numeric Overflow occurred during computationThank you.  That worked to eliminate the error message.  However, I'm still getting too many rows with the union.  For example, I see this Group    Branch &n...
1124 Oct 2015 @ 08:49 PDTDatabaseTopicSelect Failed [2616] Numeric Overflow occurred during computationI get the Error 2616 (Numeric overflow occurred duing computation) when I run the code below.  I developed 2 separate queries that each run.  When I put them in one query and use a UNION ...
1013 Oct 2015 @ 08:13 PDTDatabaseReplyCreating derived query from 2 different tables / 3707 Syntax errorDieter...........Thank you very much.  That solved my problem........
912 Oct 2015 @ 02:36 PDTDatabaseTopicCreating derived query from 2 different tables / 3707 Syntax errorI'm trying to add a field from a different table to a derived query.  This is the first time I have tried to do this.  The query below was working unitl I added the bolded information...
814 Sep 2015 @ 02:59 PDTDatabaseTopicAdd leading zero to single digit months ,case when EXTRACT (month FROM CURRENT_DATE)  > 8 then  EXTRACT (month FROM CURRENT_DATE)  - 8  else  EXTRACT (year FROM CURRENT_DATE)  +4  end as MyD...
711 Aug 2015 @ 06:58 PDTDatabaseReplySelect failed 3810 Column / Parameter .....does not exist@Fred..........I've made the change you suggested (or at least what I thought you were suggesting) and I'm now getting a "Error 3782 Improper column reference in the search condition o...
610 Aug 2015 @ 09:10 PDTDatabaseTopicSelect failed 3810 Column / Parameter .....does not existI inherited the code below and am trying to add 2 new fields to the results (bolded below).  The code I'm using to join is also bolded below.  I'm sure it is something I'm don...
507 Aug 2015 @ 11:10 PDTDatabaseReplyError 3782 Improper column reference in the search condiditon of a joined tableToddWalter.....I saw that when I made the change suggested by Rglass and fixed that.  The query just ran and returned the results I was looking for...
407 Aug 2015 @ 11:09 PDTDatabaseReplyError 3782 Improper column reference in the search condiditon of a joined tableThank you for your advice.  That did the trick. 
307 Aug 2015 @ 07:28 PDTDatabaseTopicError 3782 Improper column reference in the search condiditon of a joined tableI'm geting an error 3782 when trying to add the last 2 fields in the first selet statement and I don't know what is wrong.  Any help would be appreciated.  Thanks..... select &...
213 May 2015 @ 02:02 PDTDatabaseTopicDerived table error / object contains restricted characters with drvd_amts (acct_nbr, grp_br_ps_org_id, PSAmt) as (select d.acct_nbr, d.grp_br_ps_org_id, sum(d.pstd_ttl_amt) as PSAmt from psfs.ps_gl_acct_ldgr d where d.fiscal_yr_mth_nbr between ...
109 Apr 2015 @ 07:57 PDTDatabaseTopicError 3707 - when updating promptI have 3 prompts in my report: (1) Group Number, (2) State, and (3) Branches. The user selects the group number (1) and the prompt for State (2) is updated with all of the states the group does bus...