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.

I got it right but I would have gotten it wrong had there been an option that it gets created automatically on sql install.

Nevermind.

It helps when you chose the correct package to run.

I'd picked an old version in the the SQL Agent job. DOH!

Thanks

Thanks for your response.

I do not believe my issue is permissions based.

I did try a proxy account and got the same error.

Good idea to try that, thanks. (especially since it...

Oh!

I have 2013.

2012 is the leap year.

2013-02-29 is not a vaild date.

I'm awake now. :blush:

THANKS Guys!

Very sorry I did not include that. My bad.

Sorry to waste your time. I initially just thought I had the format incorrect.

How do I get around this? ...

OK, we have the format correct.

I think the problem is 2012 is a leap year.

It is failing on February...specifically the 2013-02-29 date.

The language is us_english and dateformat is mdy.

No, your code works fine for the temp table.