The Rays have it easy. They're playing an AAA team right now. The O's on the other hand are playing spoiler. They'll do anything and everything in their power, including...

hehe

quick, change the subject!

...

.....

Using singular table names is a Microsoft best...

I don't want to hear it.

2 games to go, we're fine. This ship is NOT sinking!

Cadavre (9/27/2011)

---

Just to prove that I do listen when I'm taught...

Have you checked that link? There's all the date conversions and date manipulations you'll ever need there.

DATEADD(YEAR,-2,cast(CURRENT_TIMESTAMP as DATE))

You can run checkDB on the production database. Just schedule it to run at an off peak time (weekends, nights, etc.).

You would more likely use the restoration process to verify...

Express12 (9/27/2011)

---

This statement renders 2 years ago today:

SELECT DATEADD(dd, DATEDIFF(dd,0,GETDATE()) -730, 0)

How can I modify the above statement to use the YEAR instead of dd -- to obtain same result?

(eg......

martin.kerr 34088 (9/26/2011)

---

Hi All,

I am trying to use this select statement:

select * from [MCM_DQ_PASS1B].[dbo].[View_Pass1bAccounts] where dqflag = 'M' or dqflag = null and expr2 = null and pass2 =...

sooo,

I went to the Nationals final home game of the season last night against Atlanta. The wildcard implications with an Atlanta loss could be seen quite visibly on the faces...

AL

wow! Boston was able to take one from New York with a 3 run jack in the 14th.

Tampa pulled off another win over Toronto which leaves them 1 game...

This is what I was able to come up with to find the monthly calendar week number.

DECLARE @dt DATETIME = '9/25/2011'

select DATEDIFF(week,DATEADD(MONTH,DATEDIFF(MONTH,0, @dt),0),@dt)+1

Maybe not the best...

This got me looking around for a solution to find calendar week numbers (defined however you'd like but for the sake of this discussion we'll assume a static sun-sat). You...

I've run into something similar to this before, it might have been with 2005 and 2008.

Long story short, 2005 was installed and before I could install 2008 as a...

Alright, that is sketchy. I don't know what the problem is but if I had to guess, you might be failing some pre-reqs. If you've used this same iso to...

First, you need to find out why it's failing.

Do you know for sure if it...