using dd with

SELECT DATEADD(dd, DATEDIFF(dd,0,GETDATE()), 2) will give you two days from now

SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 2) will produce today's date not Start of the day 2 days from now as you stated.

Good idea to have scripts for dates

good article, can't wait to try it Thanks;)

I looked at it: 2 to the 31st power is

2147483648---ackkkk sorry wrong, didn't even think of datatype. I suppose I could have run it in the query analyser and got...

Thanks Steve, Sometimes it seems like an us vs. them. Users seem to want more than what is possible. Developers act like the keepers of the data, and will...

Of course the site is we, I was just having fun

What? We wish you a new car, you were not vert clear. You should have defined which we, we is.

Yes should work with creating a stored procedure and scheduling it , the SQLAgent has the rights needed

First create a linked server to Oracle server. Then select *

into MyTableName

from openquery(YourLinkedServerName, 'place query text here') FYI Oracle does not seem to understand " quotes so I always...

I agree with newbie on the Enterprise Manager linked server to oracle. I have used OLEDB MSORA, but sometimes use Oracle OLE. Once you have the link connected, using Query...

I've been there. When your boss is threatened by your expertise. That sour taste they have never goes away and work conditions can be unbearable, even when you are doing...

I just got that exact issue resolved.  I was running my jobs (enterprise manager) which included queries against linked Oracle server using MSDAORA. It was running just fine. All of a sudden I...