Search results for query: *

Thanks for the above example.

mberni, please explain this stmt. Thanks....

PHV, Thanks for looking at this, and I'm sure your time is very valuable. My requirements have changed and I no longer have a need for this. HOWEVER, using the sample table above, I still would like to know if, and how it could be done.

Sorry, wrong table (prjobcls). It's the pay table. I only want the records for the largest FTE(s) (prep_fte_pct) for each employee. Table Name: premppay Column name Type Nulls prep_proj smallint...

I said that the above works (I thought), but it does not. Table Name: prempmst Column name Type Nulls prem_proj smallint yes prem_emp integer yes...

Thanks PHV, I tried everything but that. This is the first time using case, and it's pretty cool!!! Can you help me with this one, man, I'm really stumped: http://www.tek-tips.com/viewthread.cfm?qid=1581452&page=1

How do you label the column using a case stmt? I want the prem_term_date case labe to be "DISABLED", but AS "DISABLED", gives me an error. SELECT prem_fname || " " || prem_lname AS NAME, " " AS LOGON, " " AS EMAIL, CASE WHEN prem_term_date IS NOT NULL AND...

I only want the record with the largest FTE, but I don’t want the FTE in the output. example: Select a, b, c from table where x = MAX(x) Data: a b c x --------------------- sam 111 aaa 1 sam 222 bbb 2 sam 333 ccc 3 bob 555 eee 8 bob 222 bbb 4 bob 999...

Thank you very much PHV......

How can I select dates where date > currectDate - 120

Thanks everyone for your response. ishnid, I like use your solution. I assume there is no special variable that contains the return values of a sub. This is actually my question.

mikrom, I'm not sure we're on the same page here. My question is does this: return('value') set a special variable, say $something, so I can say $x = $something in main? Like this abc('a','b','c') put these parms in @_.

Is the rtn value from sub() in a special variable, so I don't have to call sub() twice? i.e.: $x = $1 if sub(); I'm doing this: $x = sub() if sub(); I don't want $x set if sub() returns false.

Annihilannic and polani, I'm in class all week. I'll try this again next week. Thanks for your responses.

Annihilannic, I'm stumped again. I followed the instructions in http://www.tek-tips.com/faqs.cfm?fid=6461 for both, and Linux to Linux works fine. But Linux to Unix fails. Any ideas? I was just test rsync on Unix, but if it works I'll be going Linux to Linus anyway. I make a root dir on irv001...

Annihilannic (MIS) Oh, I forgot about: rsync -avz /etc/group pentapp2:/etc

...the script below, and tell me what you think. Thanks in advance #from pentapp1 / root cron: export RSYNC_PASSWORD="mypasswd" rsync -avz /etc/pass* pentapp2:/etc # moves passwd passwd- rsync -avz /etc/*shadow* pentapp2:/etc # moves shadow shadow- gshadow gshadow- # create any...

...program", and got lost, because which ssh-add gave (/usr/bin/ssh-add), but ssh-add gave this: Could not open a connection to your authentication agent. And now: export RSYNC_PASSWORD="mypasswd" rsync -avz *.unl pentapp2:/home/ejaggers/Tmp gives: Enter passphrase for key '/root/.ssh/id_dsa':

...not copy the contents of the directory. I can’t find a tutorial that is helpful. To get the feel of rsync I’ve done the following using RSYNC_PASSWORD=”mypasswd”, but it still asked for a passwd. What am I doing wrong? export RSYNC_PASSWORD=”mypasswd” rsync -avz *.unl...

Thanks for the tip Trojan.