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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by emoongq

  1. emoongq

    Blank Mail originator

    I already did it and it worked the issue now is that part of my mail messages are not delivered. Tks
  2. emoongq

    Blank Mail originator

    Hello, I've an issue with my Exchange 5.5 server, I can see in the outbound meesages queue a big list of blank originators, they appear just like that: <>, I know there is no more support for this verison but maybe somebody knows how to prevent this issue, it is generating a lot of traffic in my...
  3. emoongq

    POP3 server automatically changes to localhost

    Hello Guys, I'm not sure what really worked but I've disabled the e-mail checking component and updated the SP3 for office and it is working now. Tks a lot
  4. emoongq

    POP3 server automatically changes to localhost

    I have office scan by Trend Micro but this is the only one PC with that issue all other pc's have the same antivirus.
  5. emoongq

    POP3 server automatically changes to localhost

    Hello, I have a user who uses pop3 without any problem but sudenly the incoming mail server changes automatically to "localhost" instead of the correct pop3 server address, I have to change it in a daily basis and don't know why this is happening, a virus, maybe? Tks
  6. emoongq

    Weird Characters

    I'm exporting to a txt file and never importing data to the source files
  7. emoongq

    Weird Characters

    I've created a DTS that was working great but since last thursday it is creating weird characters non ascii and don't know why, any idea? Tks
  8. emoongq

    Replace values

    I'm not able to save the view or even run it on a DTS, any idea? Tks
  9. emoongq

    Replace values

    Hello I'm creating a view in which I need to replace values in a field named status from 'M' to 'C', is it possible, how? Tks
  10. emoongq

    TXT CREATION FROM DTS SUCCESFULLY DONE

    Tks Alex, I'm not a programmer, I just made some SQL queries, this file I need is a five field file. Export date; Export time; filename; count; balance. I just need to put the information about 5 other previous created files. Exportation date & time, the name of the file (static field) count...
  11. emoongq

    TXT CREATION FROM DTS SUCCESFULLY DONE

    I don't know how does the standard loggin works, I didn't even know about it. Please give me an idea Alex. Tks
  12. emoongq

    TXT CREATION FROM DTS SUCCESFULLY DONE

    I'm creating 5 txt files with DTS getting info from SQL tables, now I need to create a 6th file (log) validating that the first 5 files are well done, but can't imagine if ther is a way, hope my explanation is ok.
  13. emoongq

    How to get the ID of the latest modified record

    You're the best, I really apreciate your help, this is the second time you save me. you really understand the root of the problem. Tks again
  14. emoongq

    How to get the ID of the latest modified record

    Tks George, you're always there! I've made some corrections: SELECT dbo.INVENTORY_TRANS.PART_ID AS Part_ID, dbo.INVENTORY_TRANS.TRANSACTION_DATE AS Last_trans_date, DATEDIFF(month, dbo.INVENTORY_TRANS.TRANSACTION_DATE, GETDATE()) AS Inactivity, dbo.PART.QTY_ON_HAND...
  15. emoongq

    How to get the ID of the latest modified record

    Hello, I'm not fluent on SQL ANSI, so let me explain, I've the following data and need to get only the newest record of each part_id, my sript is at the end. Part_ID Last_trans_date Inactiv Qty_on_hand 000004014658 2006-05-05 00:00:00.000 14 28.0000 000004014658 2006-06-12...

Part and Inventory Search

Back
Top