Recent content by bcdixit

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.