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

Annihilannic, I got rsync to work thanks to the tip above. As you probably already know, this thread is piggy backing: http://www.tek-tips.com/viewthread.cfm?qid=1559332&page=1 which is about keeping users in sync between 3 boxes. Please check out the script below, and tell me what you think...

Okay, I tried to setup ssh based on tutorial, "http://suso.org/docs/shell/ssh.sdf". I got to "Using the ssh-agent 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...

I want to move some files in /etc from box pentapp1 to boxes pentapp2 and pentinf1. I also want to create /home directories from pentapp1 if they don’t exist on pentapp2 and pentinf1, but not copy the contents of the directory. I can’t find a tutorial that is helpful. To get the feel of rsync...

Thanks for the tip Trojan.