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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ejaggers
  • Order by date
  1. ejaggers

    Help Find Max record using SQL

    Thanks for the above example.
  2. ejaggers

    Help Find Max record using SQL

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

    Help Find Max record using SQL

    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.
  4. ejaggers

    Help Find Max record using SQL

    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...
  5. ejaggers

    Help Find Max record using SQL

    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...
  6. ejaggers

    Need help with case stmt

    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
  7. ejaggers

    Need help with case stmt

    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...
  8. ejaggers

    Help Find Max record using SQL

    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...
  9. ejaggers

    Help w/ date sql

    Thank you very much PHV......
  10. ejaggers

    Help w/ date sql

    How can I select dates where date > currectDate - 120
  11. ejaggers

    Return value from subroutine

    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.
  12. ejaggers

    Return value from subroutine

    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 @_.
  13. ejaggers

    Return value from subroutine

    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.
  14. ejaggers

    Need help learning rsync

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

    Need help learning rsync

    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...
  16. ejaggers

    Need help learning rsync

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

    Need help learning rsync

    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...
  18. ejaggers

    Need help learning rsync

    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...
  19. ejaggers

    Need help learning rsync

    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...
  20. ejaggers

    Garbage in output file when using cron.

    Thanks for the tip Trojan.

Part and Inventory Search

Back
Top