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!

Recent content by rob1070

  1. rob1070

    Need parameter value from outer query?

    Markros Thank you very much the index was the issue the Query went from over 2 minutes to 1 second :)!
  2. rob1070

    Need parameter value from outer query?

    Thanks for the Suggestion Markros I tried The Union ALL and it did not make any difference in speed. How would I implement the join Condition?
  3. rob1070

    Need parameter value from outer query?

    Thanks to EVERYONE you guys are great. I have a working query now and It runs pretty Quickly, However I had to add another field from another table "Dictations" after adding this inner join so I can get "DOS" the query runs VERY slowly. Can you tell me if there is a better way to do this SELECT...
  4. rob1070

    Need parameter value from outer query?

    Thanks to everyone, as you can tell I am pretty novice in the advanced query area. I would indeed be interested in a better way to construct this query. I think it would help me better understand the best way to handle this type of situation in the future. Thanks Rob
  5. rob1070

    Need parameter value from outer query?

    I have the following Query in which there is a Subquery However I don't know how to supply the values to my parameter values from my outer Query nor am I sure I can do this The subquery pulls in 5 values A1-A5 to the dataset but I am not sure how to feed the values for @Dictid and @Pid to the...
See more

Part and Inventory Search

Back
Top