Search results for query: *

I am automating the process and want to send out the email sheet at a particular time of the day... so doing this manually is not efficient and does not meet the need

Hi, I am new to vbscript. I wanted to copy contents of a excel sheet into the body of any email. Is there a way to do it. I know how to attach the excel file but wanted to copy some contents inside the excel worksheet directly into the email body. the reason being, very few people open the...

I have the following piece of code, #!/usr/bin/perl $txt = "xxx yys"; $txt =~ s/\b/\!/g; print "$txt\n"; basically I want to substitute at a word boundary a '!' character but not on the first word of the string or line. the output that I am currently getting is !xxx! !yys! I want it to...

i work on teradata primarily.. 'select' can be written as 'sel' (teradata extension)....thanks for pointing that out r937. i should have changed sel to select in the forum

clone, the ouptut that you have given doesnot include all Dogs . Fluffy is missing from the output. well anyway i guess here is another way of doing it..any little more complex but I dont know if this works on SQL server or MySQL. sel z.name, m.notes,m.date_id from bi_stg_8.t1 z left outer...

r937 is correct. co-related sub query is what it is called.

joedsilva, this is exactly what i wanted!!! awesome!..thanks a ton. -bd

I have a data set that looks something like this in a table storeID DealerCD DealerName DealerPermit ------- -------- ---------- ---------- 1111 980038 John PAC 1111 980041 Bill NAC 1111 980041...

Thanks JarlH, the query works on other databases but unfortunately this doesnot work on Teradata. sorry should have mentioned that earlier.

I have a data set that looks something like this in a table storeID DealerCD DealerName DealerPermit ------- -------- ---------- ---------- 1111 980038 John PAC 1111 980041 Bill NAC 1111 980041...

Hi, I want to write a script to import mappings and session automatically. I understand that this can be done using pmrep and the ObjectImport Method. What i am missing is the import control file. can someone please let me know if I can find a sample of it somewhere? thanks

sorry , I did not mention this earlier but this is on unix.

Hello, I have a perl script in which i need run some other perl script. The way I am doing this is through the system command i.e. something like this. while(<read script names from a file>) { system("$script"); } now, what I want to do is on the screen (STDOUT), I want to display something...

I checked Millers Link.. sorry but can you help me understand what is the "inplace editor"?

still the same error after ishnids comments. I don't think this module is availalle on the box....and its a pain in the axx to get the sysadmin to compile it.

is there another way of doing this... I am getting this ... Can't locate TIE/File.pm in @INC (@INC contains: /opt/perl5/lib/5.6.1/PA-RISC2.0 /opt/perl5/lib/5.6.1 /opt/perl5/lib/site_perl/5.6 .1/PA-RISC2.0 /opt/perl5/lib/site_perl/5.6.1 /opt/perl5/lib/site_perl .)

How do I write to the same line in a file after reading from the that line. #!/usr/contrib/bin/perl $i = "c.txt"; $flag = 0; if (-e $i ) { open(RW,"+<", $i); } else { open(RW,"+>", $i); print RW "0"; $flag = 1; } if($flag == 0) { while(<RW>) { $tmp = $_; } $tmp=$tmp+1...

Hello, I am trying to write a perl wrapper script that runs multiple other perl scripts. I want to get status of those perl scripts and status of those scripts on stdout. Here is a brief explanation of what I want to do. i have a script perl_wrapper.pl and three scripts perl_1.pl, perl_2.pl and...

yes, this worked for me. thanks

I am running this query and basically I want to insert the row count values from diff_x and diff_y into tl_compare table. this query bombs on me. UPDATE bi_stg_1.TL_COMPARE from diff_x x, diff_y y SET count1 = ( select count(*) from x), count2 = ( select count(*) from y) WHERE...