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...

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...

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...

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

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...

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.

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...

Hello, I have a file that is As2'd to me named BC090602.txt. Every week the numbers in the file name change. So next week the file will be named BC090603.txt. How can I change my script to look for the BC characters then change orginal filename to just BC.txt no matter what the numbers are...

Anybody know of a way to grab an attachemnt out of an email and send it to a folder on my server? Mucho grassyazz!

How can I start two jobs simultaneously using a batch file? For example... Batch file includes: D: perl script.pl perl script2.pl How can I start these two scripts at the same time? Thank you.

How can I update two tables with the same record using different id's? First record: 1 Mexico Cancun Second record: 2 Mexico Cancun The first columns id does not match the column id located in another table. I'd like to update by id, whenever someone updates existing records...

What's the syntax for calling a stored procedure located on another DB on the same server? Thanks in advance.

Hello, How can I insert these parameters into another table in another db using a stored proc? Making sure that both id's are not duplicated? ALTER PROCEDURE [dbo].[pUpdateAn] @Parameters... set nocount on declare @NextId int declare @RowCnt int if (@Action = 0 ) begin Select...

Thanks in advance, I'd like to print only the first 25 characters of a 40 character line from error.log/@lines. if (@lines) { open FILE_LOG, ">", "error.log" or die $!; print FILE_LOG @lines; } How can I output only the first 25 characters (redundant). Happy 4th of June

Hello, I"m trying to ping a server from another server using code below and I installed the mod but keep getting this error --> Can't locate object method "new" via package "Net::Ping" (perhapes you forgot to load "Net::Ping"?) at ping.pl line 4. Mucho Grazzyazz, in advance. #!/usr/bin/perl...

Thank you in advance, Little help please? I'd like this script to know whether there is text printed to FILE_LOG and if there is no text than do not open FILE_LOG just die or unlink (delete). open FILE_LOG, ">", "error.log" or die $!; $LOGFILE = "keeplogging.log"; open(LOGFILE) or die("Could...