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 strongm 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: rrmcguire
  • Content: Threads
  • Order by date
  1. rrmcguire

    writing sql script to update fields

    I have 2 tables, payee and drs_payee. I'm trying to update the email in payee but add to the email address which is already in that field. I want to just update this email and set the field email_summary = 'Y' when the field factoring_company_id = 'OTRCCHIL' from the drs_payee table. Problem is...
  2. rrmcguire

    group policy to set dns

    Looking for a group policy to set primary and secondary dns settings to push down to end users' machines...currently have setup a login script batch file with the following but it is not updating...any help would be appreciated. @echo off set dnsserver=primary ip set dnsserver2=secondary ip for...
  3. rrmcguire

    removing whitespace

    Im trying to remove the whitespace after the title and the Meadow Lark Companies link.....this is for an email signature...but when I send the email there is a gap of whitespace in between it....could someone take a look at this as I'm not sure exactly what to remove to get rid of this...
  4. rrmcguire

    exchange 2010 running high physical memory

    Hello we have exchange 2010 setup on Windows Server 2008 R2 Hyper V, and have 20 GB of memory assigned to the VM, but the physical memory always about mid day gets up to the 97-99 % range, I understand the store running high utilizing as much memory as available, but what else could be causing...
  5. rrmcguire

    remove trailing zeros

    I have a formula CONCAT('0','order_id') and when I run this is adding the zero to the beginning of order_id but is also adding 15 trailing zeros...is there any way to remove these? thanks
  6. rrmcguire

    ifnull

    I have a field 'days to pay' and when it is null want to show the value = 30. so I have IFNULL(`daystopay`,30) but if its not null to show whatever the value is in 'daystopay' Can someone tell me how to do this? thanks
  7. rrmcguire

    sql query today plus 3

    How would I write a query to pull only the orders where sched_arrive_early = today + 3 So select * from orders, stop where orders.id = stop.order_id and stop.sched_arrive_early = 't + 3'
  8. rrmcguire

    case formula to rename columns

    Is it possible to rename columns for instance if I have a field called reason_for_leaving with the possible selections being AGT,AL, ATT, BKS, DIS, DL,DTI,EOB,FOL,FR can I have it so if reason_for_leaving = 'AGT' then 'Agent and Driver Left' else if reason_for_leaving = 'AL' then 'Agent Left', etc.
  9. rrmcguire

    sum field based on criteria

    Hello I have a bunch of records which the amounts of those are needing to be summed based on their source. i.e. sum(amount) where source = 'DRS' or sum(amount) where source = 'CASH', etc. so basically I have a group of records SUMSOURCE 1000DRS 2000DRS 3000CASH 4000CASH 5000CASH how would...
  10. rrmcguire

    how to do a join after doing a union between 2 tables

    We have 2 tables, gl_ledger and gl_ledger_hist which we have done a UNION ALL with as select * from gl_ledger UNION ALL select * from gl_ledger_hist and it brings in our data from this, but we also need to join the data together with a third table, gl_account which has a different of columns...
  11. rrmcguire

    rule to purge inbox after 90 days

    Is there a way in the exchange console to move everything which has been sent to a users' inbox to the deleted items after 90 days?
  12. rrmcguire

    Excel find actual values

    I have three columns of values 1st column is all order numbers 2nd Column is all weights 3rd column is the orders I need(for a pivot table) The first column has all the orders and the second has the weights for these orders but I need to somehow from the weights in the second column match them...
  13. rrmcguire

    rule to forward email which contains pdf

    Is there a way to setup a rule within outlook or the exchange console to forward an email which contains a pdf to another address? thanks
  14. rrmcguire

    is there a way?

    Is there a way to through a powershell script when wanting to count the number of received emails to only grab the initial ones sent to a user and not any replies, or CC's? thanks for any help provided
  15. rrmcguire

    create rule to reply back to distribution group

    Is there a way if a user is a member of a distribution group and an email gets sent to that group that a reply can be sent back to the sender?
  16. rrmcguire

    auto reply to distribution group

    Is there a way to setup a rule on someone's outlook client or through the exchange console if they are a member of a distribution group and someone emails into that distribution group it sends a reply back to that sender? thanks
  17. rrmcguire

    powershell script to forward email

    Hello, Im I have two powershell scripts one to forward email and one to stop the forwarding to another address, but am trying to set up a scheduled task so that the script first script runs at a certain time to start the forwarding and another to stop it. Both scripts when run manually work...
  18. rrmcguire

    linking this field to another.

    I have a field in one table, Customers which is basically a text field which contains: 443069 5/3/11 received bond pmt of 87.26 on 7/11/11 In my other table, shipments, I have a field recno, which contains the same number 443069 Is it possible to link two tables together in Crystal Reports...
  19. rrmcguire

    open javascript new window...

    at my page at www.meadowlarkco.com/customersnew2.php, within the customer referrals in my HTML which beings with the variable marqueecontent, is it possible to open a new window with the links, similar to this...
  20. rrmcguire

    lining up logos

    at my page at www.meadowlarkco.com/customersnew2.php in the customer referrals section how can I go about lining up the logos with the text next to them? Do I need to create a CSS for each?

Part and Inventory Search

Back
Top