Yeah, you are certainly correct. Not sure what I was thinking when I posted this. Maybe got confused with min date in sql server 2005 which I believe...

Thanks for the question. One thing that confuses me is why

Select Cast(0 As DateTime) returns 1900-01-01 00:00:00.000

and

select datediff(dd, 0, getdate()) returns 40295 and is calculating the difference from...

Thanks for the replies! I'm guessing a CLR will be the best performer, but my current dataset isn't big enough to need it yet. But I may feel...

Nice explanation. Thanks for the reply.

- Steve

Thanks everyone for all your help and suggestions. I'll need to do a bit of research on bcp to see if I can understand what is going on. ...

Thanks for the reply. Password for my local sa account is null. Connection works fine, in fact it creates a blank output file. If I change the...

Thanks for your help.  That will work great.  I'll probably need to use a cursor, but it's not that much data so I can live with it.

- Steve

Thanks for the reply.  Unfortunately I don't really know the formula until after the insert statement.  There is a bit of a mess parsing out the variables just to get the...