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.

Here is what my table looks like:

CREATE TABLE [schema].[census_date](

[id_col] [int] IDENTITY(1,1) NOT NULL,

[start_dtime] [datetime] NOT NULL,

[end_dtime] [datetime] NOT NULL

I'm fairly sure I have the format correct.

When I run your select...

No trigger.

This is a 2008 sql server. I accidentally posted under 2005 forum.

Pretty sure you get an email (with a Cert ID)...then you can sign onto the mcp.microsoft.com site and print your certification.

Congrats, nice work! 🙂

I got a chuckle...nice.

Been there done that...struggle all day, come in the next day and, D'oh, I should have thought of that. 😀

Ah...thanks!

I passed mine a couple of days ago too! I'm planning to take 70-450 next.

Yes, it gave me just what I was looking for. Thank you!

Understood. You are absolutely correct and I will definitely apply this lesson learned in the future.

Thank you very much for assisting me despite my short sightedness.