Wow, that was easy!

Thanks, it gives me what I'm looking for! Appreciated!

Your example got me passed my error.

I'm good now.

THANKS!

Thanks for your response Laurie.

That is how I was initially attempting to get it done but I was struggling with the Cross Apply.

I appreciate your method.

Thank You Andy, that does give me the desired outcome.

I apologize but I left out one detail.

There are other Obsv Codes that begin with A_Med1 etc. (like Dosage,...

anthony.green (7/19/2012)

---

I also read it as being Yes as the question didnt specify needing to delete or not delete the other snapshots, so in theory Yes I can revert to...

Call the vendor. Don't you have support from the vendor of the RX App?

I agree with the other posters, the ODBC config it is looking for isn't there.

Thank you Mark.

Remember I said I'm still learning?

Can someone show me how to do this without using the temp db (all in one statement)? I know it is a nested select...

A good week is when I fix more things than I break! 😎

Thanks Rob, yes that is needed.

Great, thanks, I knew it was easy. I'm still learning.

Many Thanks!

It gives me an error with grouping on fields selected with '*'.

Here is what I have now:

SELECT DISTINCT Stays.[Billing#], Orders.[Order#]

FROM Stays INNER JOIN (Test_Results INNER JOIN Orders ON Test_Results.ACT_ATEST =...

Great, thank you for the advice.

Strange, I removed the Group the domain user is in and re-added it back with Full Control and now it works. It does not look any different than before....

It does work with Everyone having full permissions.

I will verify the account the review the permissions again.