Search results for query: *

Hi, I'm looking to combine two values in one column in my results. For example, I have a value of apple and a value of orange in PRDRST_L4_MAIN_DSC and I'm joining to pull specific ITEM_ID's however I need all ITEM_ID's that belong to Orange and Apple to sum SALES together in on row. Results...

My apologies, wrong forum. Thank you for your help

This is what I have to pull the totals for each PRDRST_L4_MAIN_DSC. I want to combine only two PRDRST_L4_MAIN_DSC out of about 12. select a19.WK_NBR_ID WK_NBR_ID, a11.STATE_ID STATE_ID, a16.MAIN_DSC MAIN_DSC, sum(a11.SALES_AMT) TOTAL from SALES a11 join ITEM_L...

Hi, I'm looking to combine two values in one column in my results. For example, I have a value of apple and a value of orange in one column and I'm joining another column called total sales. I want my results to show Product Total for both products Apple/Orange...

My update statement is returning an error = ORA-00904: "STORE_DETAIL": invalid identifier I'm trying to update STORE_DETAIL based on the matching store_id's in another table. UPDATE STORE_DETAIL_L SET (STORE_DETAIL) = (SELECT WM_STORE_TYPE_DESCR_TXT FROM GEO_STORE_L WHERE...

I'm trying to update a table based on the values of another column in another table. For example, I have a column called Store in a table called T_STORE. This table has approximately 200 rows and each store has it's own description in a column called Store_Description based on the STORE_FORMAT...

Thanks for your help guys... I really appreciate your answers. Your wondering has given you the answer... I want it to break in six months. Thanks again!

I think so too it fails to execute on the newline you created

I'm trying to offset %W by 4 weeks and I'm unable to get it done. Can someone help me please? TY #!/usr/bin/perl use POSIX qw(strftime); our $today = strftime("09%m%%W%d", localtime); foreach my $file (<AC*.lkp.z>) { rename ($file, "AC$today.lkp"); last; # so we only rename 1 file

perl babelfish.pl I want the script to read the input file "autobad.log" and eventually write a log with the English interpretation of all Chinese characters. #!/usr/bin/perl use strict; use warnings; use Babelfish; # input file to translate # specified as command line argument...

input_file = autobad.log

Help, Having trouble getting the translation... code follows: Getting an error -> usage: ./translate.pl autobad.log at babel.pl line 9. Thanks #!/usr/bin/perl use strict; use warnings; use Babelfish; # input file to translate # specified as command line argument my...

Uh oh, my apology for the confusion. Encoding flac files all day hence the "encode" typo. Sorry buddy. Thanks

WWW-Babelfish-0.16 <-- does the trick. Thanks anyway.

Is there a way to encode chinese characters from a log file into good ole Engish? I have a script that pulls information that is in Chinese. Thanks

Is it possible to execute a batch file that resides on a server from my local PC? Hence, not remote into the server and execute via personal PC. Thanks a million.

Nevermind I just used POSIX qw(strftime). Thanks again.

Thanks a million, works perfectly. How can I include the current date after the BC in BC.txt? Ex: foreach my $file (<BC*.txt>) { rename ($file, "BCyymmdd.txt"); last; # so we only rename 1 file }

Cheers, Help please, looking to take a reoccurring email message that I recieve every week. The message contains an attachment that I need placed on a folder on my server (trying to avoid FTP). I want to Automate by forwarding to a folder on my server? I only want the attachment not the...

Cheers, Help please, looking to take a reoccurring email message that I recieve every week. The message contains an attachment that I need placed on a folder on my server (trying to avoid FTP). I want to Automate by forwarding to a folder on my server? I only want the attachment not the...