Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
copy paste contents of a excel worksheet into outlook email body
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 -
copy paste contents of a excel worksheet into outlook email body
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... -
regex question : ignoring first match in pattern search
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... -
left join with unique rows from joined table?
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 -
left join with unique rows from joined table?
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... -
left join with unique rows from joined table?
r937 is correct. co-related sub query is what it is called. -
getting distinct values of a column in a partition query
joedsilva, this is exactly what i wanted!!! awesome!..thanks a ton. -bd- bcdixit
- Post #3
- Forum: NCR: Teradata
-
getting distinct values of a column in a partition query
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...- bcdixit
- Thread
- Replies: 2
- Forum: NCR: Teradata
-
finding distinct values in a partition query
Thanks JarlH, the query works on other databases but unfortunately this doesnot work on Teradata. sorry should have mentioned that earlier. -
finding distinct values in a partition query
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... -
Informatica power center: import control file
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- bcdixit
- Thread
- Replies: 0
- Forum: Data Management Tools general discussion
-
listening to a process in Perl.
sorry , I did not mention this earlier but this is on unix. -
listening to a process in Perl.
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... -
read a line from a file and writing to the same line in the file
I checked Millers Link.. sorry but can you help me understand what is the "inplace editor"? -
read a line from a file and writing to the same line in the file
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. -
read a line from a file and writing to the same line in the file
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 .) -
read a line from a file and writing to the same line in the file
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... -
running one perl script from another
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... -
help in update select statement.
yes, this worked for me. thanks- bcdixit
- Post #3
- Forum: NCR: Teradata
-
help in update select statement.
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...- bcdixit
- Thread
- Replies: 2
- Forum: NCR: Teradata
