Viewing 15 posts - 8,701 through 8,715 (of 10,144 total)
Michael Valentine Jones (3/11/2009)
Shorter.
select [Month] = right(100+month(getdate()),2)Results:
Month
-----
03
Interesting...
Noticed this while messing with possible solutions...
SELECT
GETDATE(), -- Current Datetime
LEFT(GETDATE(), 19), -- StringDate 'Mar 11 2009 2:10PM'
CAST(LEFT(GETDATE(), 11)...
March 11, 2009 at 8:17 am
Bruce W Cassidy (3/10/2009)
Lynn Pettis (3/10/2009)
Effort worth expending not.[font="Verdana"]Forth like honk if.[/font]
Well oil beef hooked!
March 11, 2009 at 3:19 am
Wayne (3/9/2009)
March 10, 2009 at 1:43 pm
Roy Ernest (3/10/2009)
Here is someone who is almost ready to drive people nuts...
Well worth reading for Brandie's definition of RBAR 😀
March 10, 2009 at 8:20 am
Dugi (3/9/2009)
This should work let us know:
SELECT * FROM TBLDEALS
WHERE CONVERT(VARCHAR(20),trade_date, 120) = '2009-03-06 00:00:00'
It might work, Dugi, but it's not going to be quick! Far better to convert one...
March 9, 2009 at 8:58 am
GSquared (3/9/2009)
RBarryYoung (3/7/2009)
As Woody Allen once said:"I'm not sure I want to join any club that would have me as a member."
Either he stole that one from Groucho Marx,...
March 9, 2009 at 7:20 am
A Little Help Please (3/9/2009)
where trade_date = '2009-03-06 00:00:00'Assuming trade_date is a datetime column, what do you think the result of the implicit conversion of the string '2009-03-06 00:00:00' to...
March 9, 2009 at 7:04 am
DURGESH (3/9/2009)
if my table is as follows
col1 col2 col3
aa ram b
bb ram a
cc ravi ...
March 9, 2009 at 6:46 am
Jeff Moden (3/7/2009)
;WITH
cteGroup...
March 9, 2009 at 3:41 am
GilaMonster (3/8/2009)
Jeff Moden (3/7/2009)
Consider the OP in the following... Lynn may have competition for saint-hood... 🙂http://www.sqlservercentral.com/Forums/Topic670491-338-1.aspx
Mike is one of those people on my blacklist, due to his repeated demonstrations that...
March 8, 2009 at 9:33 am
Steve Jones - Editor (3/6/2009)
I don't see how comments are rated in the New Scientist thing. I missing something?
Not really, Steve. It's simply an example of where ranking works well,...
March 7, 2009 at 2:00 am
Grant Fritchey (3/6/2009)
Remember, don't feed the trolls.
'Nuff said.
March 6, 2009 at 1:49 pm
jcrawf02 (3/6/2009)
Chris Morris (3/6/2009)
In any case, the best or, more rarely, the correct answer here is usually blindingly obvious.
To you, Chris, or to someone who knows that they're doing. ...
March 6, 2009 at 10:08 am
Here's a great example of how "mark as correct" or "mark as answered" really works. All of the answers are preserved, one or more are flagged up.
So what is the...
March 6, 2009 at 9:50 am
Ninja's_RGR'us (3/6/2009)
Nope only another 19 needed, 18 after you reply to this! 😉
Ooh will there be a party? Can I bring beer? 😀
March 6, 2009 at 9:13 am
Viewing 15 posts - 8,701 through 8,715 (of 10,144 total)