Viewing 15 posts - 376 through 390 (of 687 total)
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...
September 28, 2011 at 11:42 am
Sean Lange (9/27/2011)
I typically avoid online political discussion like the plague due the high frequency of rabid and nasty responses.
hehe
quick, change the subject!
...
.....
Using singular table names is a Microsoft best...
September 27, 2011 at 10:56 am
I don't want to hear it.
2 games to go, we're fine. This ship is NOT sinking!
September 27, 2011 at 7:27 am
Cadavre (9/27/2011)
calvo (9/27/2011)
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))
Just to prove that I do listen when I'm taught...
September 27, 2011 at 6:33 am
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))
September 27, 2011 at 6:09 am
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...
September 27, 2011 at 6:04 am
Express12 (9/27/2011)
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......
September 27, 2011 at 5:58 am
martin.kerr 34088 (9/26/2011)
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 =...
September 26, 2011 at 10:44 am
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...
September 26, 2011 at 6:45 am
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...
September 26, 2011 at 6:30 am
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 way, but it works.
September 23, 2011 at 8:49 am
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...
September 23, 2011 at 7:18 am
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...
September 23, 2011 at 6:46 am
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...
September 21, 2011 at 10:36 am
Krasavita (9/21/2011)
Where can I go and create a new password for my sql agent?Thank you
First, you need to find out why it's failing.
Do you know for sure if it...
September 21, 2011 at 10:29 am
Viewing 15 posts - 376 through 390 (of 687 total)