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 tschallb

  1. tschallb

    Conditional Statements

    Thanks Mike. That's what I thought but I wanted to double check. Tim
  2. tschallb

    Conditional Statements

    Hi Folks, We are trying to come up with a way to do an If / Then type statement in Act. For example if a field within a large database = A then Print Driving Instructions A. Act Support says that If / Then are not supported but I wonder what people have done with custom reports. Is this...
  3. tschallb

    CBL is blocking me because HELO string is incorrect???

    Hi Smah, Thanks for the response. The IP address I listed had a typo in it. The real IP is 24.199.32.210 and the reverse DNS comes back to my correct domain. Thanks Tim
  4. tschallb

    CBL is blocking me because HELO string is incorrect???

    Hi Folks, This is an odd one that I hope someone has some ideas on... Our Exchange Server has shown up on the CBL. We are not an Open Relay nor have we been infected with anything. Evidently they run a HELOCHECK on Domains that support Email and if the response they receive is "incorrect"...
  5. tschallb

    SQL Newbie - Is a Self Join what I need here?

    Hi Esquared, Thanks for the suggestion. Sometimes I overlook the obvious... That suggestion along with a couple of other tweaks have my query working great. And more importantly I believe I understand what is occurring. Thanks, Tim
  6. tschallb

    SQL Newbie - Is a Self Join what I need here?

    Hi Esquared, Here you go. Here are real snippets from the table. (Column names shortened to get info to fit...) First: Normal case "Two lines of information" INV, LINE_NO, PO_LINE, PO#, DESC, ACCT_ID, AMT 317, 0, 1, 78, Tree Pruning, 0, 39000 317, 1, 1, 78, <NULL>, 6357, 39000...
  7. tschallb

    SQL Newbie - Is a Self Join what I need here?

    Oh, so close. In testing occassionally the right record that I need to return has a ESA2.LINE_NO of 2 or higher. Which led me to the notion that I simply need to alter the command to a MAX aggregate function. I have tried the following: AND ESA2.[Line_No]=(select max(ESA2.SUB_LINE_NO) from...
  8. tschallb

    SQL Newbie - Is a Self Join what I need here?

    Hi Esquared, Thanks once again for all of your help. I was able to get the query to work! (I might be figuring out this Self Join stuff yet...). After your last suggestion I scoured the table in question looking for one more unique field that I can base my query on (the table has approx 50...
  9. tschallb

    SQL Newbie - Is a Self Join what I need here?

    Hi Esquared, Thanks for the comments. Yes, I can have multiple POs per invoice. Your last snippet of Code returns the same 16 Account Numbers for each Description. Here is the code with the return set: SELECT ESA1.PO_NUM, ESA1.ITEM_DESC, ESA1.INV_AMT, ESA1.LINE_NO...
  10. tschallb

    SQL Newbie - Is a Self Join what I need here?

    Hi Esquared, The Outer Join was just the last thing I tried... Thanks for the hint. I altered my query to the following: SELECT ESA.PO_NUM, ESA.ITEM_DESC, ESA.INV_AMT, ESA1.ACCT_ID FROM dbo.ESAINVCD ESA INNER JOIN dbo.ESAINVCD ESA1 ON...
  11. tschallb

    SQL Newbie - Is a Self Join what I need here?

    Hi Esquared, Thanks for the challenge. I don't learn anything if I just get the answer... I can't seem to get past a result set that looks like: INV DESC ACCT AMT 1 (null) 1 16.77 1 (null) 2 206.58 1 DESC 0 16.77 2 DESC 1 0 206.58 My last...
  12. tschallb

    SQL Newbie - Is a Self Join what I need here?

    Hi Folks, Last week you folks were kind enough to assist me with a situation where a Self Join solved my issue. I thought I understand Self Joins and have been attempting to get one to work without success for the following issue. Return set is: INV Line# PO Desc Acct ID AMT 1...
  13. tschallb

    SQL Query Question - Merging Data

    Hi Esquired, No, I don't understand it yet. This is the first time I have seen a Self-Join in my limited SQL real life. I have my SQL book out and I am in the process of dissecting it. hanks, Tim
  14. tschallb

    SQL Query Question - Merging Data

    Thanks ESquared your suggestion worked! Now I am working on getting the raw SQL to work in Crystal Reports. Thanks a bunch! Tim
  15. tschallb

    SQL Query Question - Merging Data

    Thanks folks. I am exloring both suggestions right now. I forgot to mention one thing. I also need to link Acct # field to Account_Lookup Table so that I can get a real Account Number returned as part of my query. Thanks for the quick response! Tim

Part and Inventory Search

Back
Top