Well, where I work we have an enterprise license and its just available for anyone who wants to use it. So it doesn't cost anything more than what we are...

Ya, coincidence I guess. I have seen some people bashing TOAD, but there are a lot of things I like about it. This is the first time I have ran...

Those problems were only with the TOAD interface. Apparently it has a problems with dates or something when doing select statements. When I ran that code in SSMS it worked...

OK, so I figured this out. It was in SSIS. I looked at the metadata for the process that was pulling this data and it had dbdate as the data...

That code works as expected in SSMS but again, not in TOAD. I am going to test some things in SSIS to see what I can figure out.

It is TOAD for SQL Server. I just tried the same code in Management Studio and it worked as expected. So something with TOAD? But the real problem is that...

I copy and pasted your code and I get the same results. If I comment out the lines in the select statement that does the casting, the results for Date1...

Thanks, I think I got it now.

Thanks Luis, I thought of that too, but didn't really want to do that because it still has to load the whole large table. Unfortunately, I don't have access to...

Thanks Steve. I took a look at the casting functions and the one for DATETIMEOFFSET was confusing me. However, while looking around in there, I did see a NULL function...

Well that was simple enough. Shame I didn't think of it.

Thanks!

It is going to be used lightly. At least initially, probably for a year or two. So it sounds like putting it on the same server would be a viable...

Great, thank you! I had seen the Expert Cube Development but wasn't sure it would cover the basics that I am looking for. I'll start with the training kit and...