Today's Random Word!

Question

Today's Random Word!

Viewing 15 posts - 5,566 through 5,580 (of 21,190 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

SQLRNNR (12/8/2011)
L' Eomot Inversé (12/8/2011)
Cadavre (12/8/2011)
Boo, missed that 😛
Here's my fixed version: -
<code snipped>
Drat, I missed out 6 casts ("0" changed to "cast(cast 0 as datetime) as date)" in three places! :blush: I was planning to wait for you (or anyone) to come up with the 24 -> 25 solution and then I could make a pedantic claim that one should use DATE not DATETIME to do date comparisons, but when it came to it I noticed that in fact I was still using datetime mostly. I can't even get the pedantry right when I'm trying to clown with it. Where's the face-palm icon?
Fits well with your new Avatar.

Maybe this one is better!

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 2

Ninja's_RGR'us (12/8/2011)
SQLRNNR (12/8/2011)
L' Eomot Inversé (12/8/2011)
Cadavre (12/8/2011)
Boo, missed that 😛
Here's my fixed version: -
<code snipped>
Drat, I missed out 6 casts ("0" changed to "cast(cast 0 as datetime) as date)" in three places! :blush: I was planning to wait for you (or anyone) to come up with the 24 -> 25 solution and then I could make a pedantic claim that one should use DATE not DATETIME to do date comparisons, but when it came to it I noticed that in fact I was still using datetime mostly. I can't even get the pedantry right when I'm trying to clown with it. Where's the face-palm icon?
Fits well with your new Avatar.
Maybe this one is better!

It loses a lot without the vocal inflection, but here goes:

Pie 😀

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

Daniel Bowlin (12/9/2011)
Ninja's_RGR'us (12/8/2011)
SQLRNNR (12/8/2011)
L' Eomot Inversé (12/8/2011)
Cadavre (12/8/2011)
Boo, missed that 😛
Here's my fixed version: -
<code snipped>
Drat, I missed out 6 casts ("0" changed to "cast(cast 0 as datetime) as date)" in three places! :blush: I was planning to wait for you (or anyone) to come up with the 24 -> 25 solution and then I could make a pedantic claim that one should use DATE not DATETIME to do date comparisons, but when it came to it I noticed that in fact I was still using datetime mostly. I can't even get the pedantry right when I'm trying to clown with it. Where's the face-palm icon?
Fits well with your new Avatar.
Maybe this one is better!
It loses a lot without the vocal inflection, but here goes:
Pie 😀

Don't you mean PANTS! :hehe::smooooth:

crookj SSChampion Points: 14075 More actions · Answer 4

crookj

SSChampion

Points: 14075

December 9, 2011 at 8:27 am

#1419419

WOTD - Recursive

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 5

Devendrakumar

SSC-Forever

Points: 42493

December 9, 2011 at 8:31 am

#1419424

crookj (12/9/2011)
WOTD - Recursive

Loop

Cadavre SSC-Forever Points: 41690 More actions · Answer 6

Dev (12/9/2011)
crookj (12/9/2011)
WOTD - Recursive
Loop

Recursive

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 7

Dev (12/9/2011)
crookj (12/9/2011)
WOTD - Recursive
Loop

Sounds about right 😀

Revenant SSC-Forever Points: 42467 More actions · Answer 8

Ninja's_RGR'us (12/9/2011)
Dev (12/9/2011)
crookj (12/9/2011)
WOTD - Recursive
Loop
Sounds about right 😀

As long as it is not infinite

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 9

Revenant (12/9/2011)
Ninja's_RGR'us (12/9/2011)
Dev (12/9/2011)
crookj (12/9/2011)
WOTD - Recursive
Loop
Sounds about right 😀
As long as it is not infinite

Keep a mental note and come back to it in 1 year. We should have a pretty good idea. :-D;-)

Peter Trast SSCarpal Tunnel Points: 4392 More actions · Answer 10

Dev (12/9/2011)
crookj (12/9/2011)
WOTD - Recursive
Loop

Iterative

Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems

Cadavre SSC-Forever Points: 41690 More actions · Answer 11

Revenant (12/9/2011)
Ninja's_RGR'us (12/9/2011)
Dev (12/9/2011)
crookj (12/9/2011)
WOTD - Recursive
Loop
Sounds about right 😀
As long as it is not infinite

I tried to make it infinite, but the person that posted after me (naming no names 😛 ) didn't quote me and reply with "Loop" to keep it going 😀

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 12

Cadavre (12/9/2011)
Revenant (12/9/2011)
Ninja's_RGR'us (12/9/2011)
Dev (12/9/2011)
crookj (12/9/2011)
WOTD - Recursive
Loop
Sounds about right 😀
As long as it is not infinite
I tried to make it infinite, but the person that posted after me (naming no names 😛 ) didn't quote me and reply with "Loop" to keep it going 😀

Exactly. 😎

bcsims 90437 SSC Eights! Points: 929 More actions · Answer 13

17 days until Christmas?

WOTD procrastination... haven't started thinking about Xmas presents yet, let alone shopping!

TomThomson SSC Guru Points: 104773 More actions · Answer 14

bcsims 90437 (12/9/2011)
17 days until Christmas?
WOTD procrastination... haven't started thinking about Xmas presents yet, let alone shopping!

17 days posted on 9th? Only if you count both the 9th and the 25th, which isn't what most people do.

Tom

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

Revenant (12/9/2011)
Ninja's_RGR'us (12/9/2011)
Dev (12/9/2011)
crookj (12/9/2011)
WOTD - Recursive
Loop
Sounds about right 😀
As long as it is not infinite

Loop

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events