Recent content by nithink

Hi, I've a date column, p_date. I need to get the minimum of p_date. Like in oracle I was trying the min(p_date) but came to know it returns the minimum of numerical value. Can anyone pls let me know how to get the min of _date ? Thanks....

Wow.. got it... thanks much...

Hi, Help using awk or sed... I've a text file which contains pipe delimited data like, 100|EQTX|EQUITY TAXABLE| 102|GTHTX|GROWTH TAXABLE| 105|CPRESTX|CAPITAL PRESER TAXABLE - PFM| 103|GINCTX|GROWTH & INCOME TAXABLE| After using sed or awk, I need an output file which just contains the...

Hi, I've a delete statement inside my unix shell script, which will delete around 8 million rows. Is there anyway that I can do frequent commits rather than doing commit after 8 million rows. I've set the autocommit option ON and the statement is given below, delete from table1 a where...

Thx Martin... It mite have been simple for yu but for me as I'm totally new to Access I dont know these small things... Thank yu and yu deserve a star...

Answer 1: SELECT IIf(IsNumeric([dbarc].[acct_num]),IIf(Val([dbarc].[acct_num])>=680000,"70-","44-"),"44-") & [dbarc].[acct_num] AS cl_id, format(dbarc.ret_date-datepart("d",ret_date),'mm/dd/yyyy') AS post_date, 'M' AS post_type...

Hi Martin, HOw to export that query output to a new table ? You were saying abt append query ... how to use that ? What I did was I exported the query output to a .txt file and then imported that .txt file to a new table.... But all the decimal values was rounded... I dont want that to...

Have started a new thread... sorry abt that...

Hi, I've a query which creates an output with many columns. I want to transfer the whole query output to a new table.. The query output has some decimal values in the columns too which I want to have it the same...It should not get rounded... I just want to have the same values in the table...

Thanks Martin very much... it worked fine... I've one more question... I've a query which creates an output with many columns. I want to transfer the whole query output to a new table.. The query output has some decimal values too which I want to have it the same...It should not get rounded...

Error: Operation must use an updatable query While running the below query, I'm getting the error, Operation must use an updatable query. UPDATE CapgComp_init AS A SET A.cl_id = (SELECT LEFT(B.cl_id, 4)&T.future_state_account_num FROM CapgComp_init B INNER JOIN current_future_acct_num AS T...

Hi Leslie, Given below is the UPDATE query I'm trying.. but its giving "OPERATION MUST USE AN UPDATABLE QUERY" Can you pls let me know.. Thanks... UPDATE CapgComp_init A set A.cl_id = (SELECT LEFT(B.cl_id, 4)&T.future_state_account_num FROM CapgComp_init B INNER JOIN...

hi Leslie, back after a break... Actually its a query output which I want to update... That is I want to change the value of cl_id to the value of Col2 in Table2 with the beginning of the original cl_id if there are any matchings with cl_id from the query output to the Col1 of the...

OH no leslie... Its a Query not a table... So how we have to do now ? Should I create some temp table and populate it and then run this update ? Thanks..

Sorry.. again forgot to mention one more thing.. If it matches with Table2's column value, I need to get the value and put it in place of that existing value. Ex: 44-228100-674700 has a matching value in Table2 as Col1 Col2 --------------------- 228100-674700 674700C1...