Today's Random Word!

Question

Post reply

Today's Random Word!

Viewing 15 posts - 3,121 through 3,135 (of 21,190 total)

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

sing4you SSCrazy Points: 2984 More actions · Answer 1

sing4you

SSCrazy

Points: 2984

October 20, 2010 at 6:56 am

#1239645

Forewarn

Ray K SSC-Dedicated Points: 31163 More actions · Answer 2

Forescore

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/

Ray K SSC-Dedicated Points: 31163 More actions · Answer 3

~~Word~~ Code of the day . . .select cup from coffee

where caffeine = 'high'

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/

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

Ray K (10/20/2010)
~~Word~~ Code of the day . . .select cup from coffee
where caffeine = 'high'

You need a loop so you can repeat, one cup is not enough.:-)

Ray K SSC-Dedicated Points: 31163 More actions · Answer 5

Daniel Bowlin (10/20/2010)
Ray K (10/20/2010)
~~Word~~ Code of the day . . .select cup from coffee where caffeine = 'high' group by cup
having count(cup) > 1
You need a loop so you can repeat, one cup is not enough.:-)

How's that?

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/

sing4you SSCrazy Points: 2984 More actions · Answer 6

select cup from coffee

where caffeine = 'high'

and spike = 'Grand Marnier'

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

Ray K (10/20/2010)
~~Word~~ Code of the day . . .select cup from coffee
where caffeine = 'high'

You won't get any that way, try this:

select coffee

Into #Mug

from Pot

where caffeine = 'high'

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

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 8

CirquedeSQLeil (10/20/2010)
Ray K (10/20/2010)
~~Word~~ Code of the day . . .select cup from coffee
where caffeine = 'high'
You won't get any that way, try this:
select coffee
Into #Mug
from Pot
where caffeine = 'high'

Boys, boys. You're doing it all wrong.

Declare @cup Wallysized, @pours int;

Set @pours = full;

Set @cup = ounces_litres;

While @cup < @pours

Begin

select p.coffee, t.n

Into #Mug

from Pot p

cross join Tally t

where p.caffeine = 'high';

Set @cup = @cup + 1;

End

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

crookj SSChampion Points: 14075 More actions · Answer 9

and

while @cup < 3

@triptobathroom = false

Gotta cover all possibilities 😉

Joe

Ray K SSC-Dedicated Points: 31163 More actions · Answer 10

Brandie Tarvin (10/20/2010)
CirquedeSQLeil (10/20/2010)
Ray K (10/20/2010)
~~Word~~ Code of the day . . .select cup from coffee
where caffeine = 'high'
You won't get any that way, try this:
select coffee
Into #Mug
from Pot
where caffeine = 'high'
Boys, boys. You're doing it all wrong.
Declare @cup Wallysized, @pours int;
Set @pours = full;
Set @cup = ounces_litres;
While @cup < @pours
Begin
select p.coffee, t.n
Into #Mug
from Pot p
cross join Tally t
where p.caffeine = 'high';
Set @cup = @cup + 1;
End

I trust that you tested this in SQL Profiler? :hehe:

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

Ray K (10/20/2010)
Brandie Tarvin (10/20/2010)
CirquedeSQLeil (10/20/2010)
Ray K (10/20/2010)
~~Word~~ Code of the day . . .select cup from coffee
where caffeine = 'high'
You won't get any that way, try this:
select coffee
Into #Mug
from Pot
where caffeine = 'high'
Boys, boys. You're doing it all wrong.
Declare @cup Wallysized, @pours int;
Set @pours = full;
Set @cup = ounces_litres;
While @cup < @pours
Begin
select p.coffee, t.n
Into #Mug
from Pot p
cross join Tally t
where p.caffeine = 'high';
Set @cup = @cup + 1;
End
I trust that you tested this in SQL Profiler? :hehe:

It doesn't look like it will pour fast enough.

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

Ray K SSC-Dedicated Points: 31163 More actions · Answer 12

WOTD: word

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/

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

Daniel Bowlin

SSC-Dedicated

Points: 34566

October 21, 2010 at 6:56 am

#1240258

dreary

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 14

bleary

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

tosscrosby SSCoach Points: 18045 More actions · Answer 15

weary - will this week ever end???

-- You can't be late until you show up.