#DateForumTypeThreadPost
2405 Dec 2012 @ 10:59 PSTDatabaseReplySQL to compare records (status change) in tableI figured it out.   select row_begin_dt, c_ams_clm, c_clm, c_sta_clm, -- Find the c_sta_clm of the previous row max(c_sta_clm) over (partition by c_clm order ...
2304 Dec 2012 @ 10:06 PSTDatabaseTopicSQL to compare records (status change) in table  I have a table that contains history of a claim. Basically I'm looking at status changes and dates. Whenever someone updates a claim, the new row is loaded into the table I'm showin...
2218 Oct 2012 @ 10:20 PDTAnalyticsReplyCase statement returning "Bad character in format or data...."Okay when i run that I'm still getting the same error rather than running and displaying "bad data"
2118 Oct 2012 @ 06:32 PDTAnalyticsReplyCase statement returning "Bad character in format or data...."Are you saying I should not cast C_POL as decimal?
2017 Oct 2012 @ 03:24 PDTAnalyticsReplyCase statement returning "Bad character in format or data...."you are right - I broke this case statement out case by case and the first line was the one sending me the message. I'm not really sure the syntax for this? is there an example anywhere?  ...
1917 Oct 2012 @ 12:33 PDTAnalyticsTopicCase statement returning "Bad character in format or data...."  I'm trying to run the following code to return a policy# formatted correctly so that I can join up with other tables and I'm receiving the following error "Bad character in ...
1813 Aug 2012 @ 07:37 PDTDatabaseReplyDate Diff function/ column not found error. Ooops I've also tried below which give me "selected non aggregate functions must be a part of the associated group"   inner join(select sorce_claim_id ...
1713 Aug 2012 @ 07:26 PDTDatabaseTopicDate Diff function/ column not found error. I'm trying to do a datediff function that grans the total # of days between todays date and a prior payment date. For some reason I'm getting an error stating that the "pmnt_rlse_dt...
1604 Jan 2012 @ 11:31 PSTDatabaseTopicTrying to get correct rank order Hello - I have the following subquery that I'm looking to rank correctly. I'm trying group or rank by Status then by cov_eff_dt(oldest). So ideally status would rank one unless there...
1503 Aug 2011 @ 07:01 PDTDatabaseTopicDuplicate Primary Key errorI have been fighting with this for weeks now. Basically I have .NET application that is using a teradata backend. I cannot for the life of me figure out why I keep getting this error, and it's rand...
1401 Aug 2011 @ 10:47 PDTDatabaseReplyQuery by date returning error vb.netSorry this is the correct SQL sSQL &= "DATE_SUBMIT = ('" & txtDateRec.Text & "')"
1301 Aug 2011 @ 08:26 PDTDatabaseTopicQuery by date returning error vb.netI'm trying to run a query from a search form by date and I'm receiving the following error: [Teradata Database] Partial string matching requires character operands. The code for the search ...
1218 May 2010 @ 12:20 PDTAnalyticsReplyNeed help with OLAP or If function in subqueryLooks like it's doing the trick! My next question is, Say there is now a CH and i want to take EE over that? While still taking RT's over EEs, etc... Or an RT but want to take CH over it an...
1118 May 2010 @ 11:34 PDTAnalyticsReplyNeed help with OLAP or If function in subqueryOkay I got it working with Select i_pol ,i_ird ,n_lst ,n_fst ,i_ssn ,d_bth From ltc_p.vltc_er_ird_mo gird Qualify Row_Number () over (partition by i_pol order by case when i_ird like...
1018 May 2010 @ 11:29 PDTDatabaseReplyNeed help with subquery IF/THEN statement, or OLAP functionSelect i_pol ,i_ird ,n_lst ,n_fst ,i_ssn ,d_bth From ltc_p.vltc_er_ird_mo gird Where gird.i_ssn = '610000000' Qualify Row_Number () over (partition by i_pol order by case when i_ird like '...
918 May 2010 @ 10:53 PDTDatabaseReplyNeed help with subquery IF/THEN statement, or OLAP functionNevermind... Got it!
818 May 2010 @ 06:00 PDTAnalyticsReplyNeed help with OLAP or If function in subqueryHere is the actual error when running the above code: 244 WHERE clm.c_pol NOT BETWEEN 'LAC000001' AND 'LAC000999' 245 AND clm.i_sys_clm not in(39323,39810,40395,4042...
718 May 2010 @ 05:51 PDTAnalyticsReplyNeed help with OLAP or If function in subqueryoptions nosource nosource2 nosymbolgen nomprint; %include 'J:\sas\password.sas'; options source source2 symbolgen mprint validvarname=v7 sasautos=(maclib macauto); /*filename maclib 'J:\sas\ma...
617 May 2010 @ 06:06 PDTAnalyticsReplyNeed help with OLAP or If function in subqueryand username.gird.nlast does not exist?
517 May 2010 @ 06:06 PDTDatabaseReplyNeed help with subquery IF/THEN statement, or OLAP functionand username.gird.nlast does not exist?
417 May 2010 @ 05:23 PDTDatabaseReplyNeed help with subquery IF/THEN statement, or OLAP functionI'm getting a syntax error with this as well as other similar test code.. c_pol does not match defined type name? Thank you very much!!!
317 May 2010 @ 05:21 PDTAnalyticsReplyNeed help with OLAP or If function in subqueryThank you for your reply! much appreciated. I'm running this code in SAS and getting the following error: CLI Prepare error: Syntax Error type c_pol does not match defined type name. Any idea...
213 May 2010 @ 07:53 PDTAnalyticsTopicNeed help with OLAP or If function in subqueryI have a pretty complex query that pulls the following "Insured IDs" from a table specified in the coalesce statement. The problem is that there are duplicate records with the exception of two lett...
112 May 2010 @ 12:32 PDTDatabaseTopicNeed help with subquery IF/THEN statement, or OLAP functionI have a pretty complex query that pulls the following "Insured IDs" from a table specified in the coalesce statement. The problem is that there are duplicate records with the exception of two lett...