September 20, 2010 at 4:13 am
September 20, 2010 at 5:27 am
Requirements
SELECT TOP 1 Convalesce = COALESCE(Sleep, Food, Drink)
FROM (
SELECT '12 hours' AS Sleep, CAST(NULL AS VARCHAR(15)) AS Food, CAST(NULL AS VARCHAR(15)) AS Drink UNION ALL
SELECT CAST(NULL AS VARCHAR(15)) AS Sleep, 'She-crab soup' AS Food, CAST(NULL AS VARCHAR(15)) AS Drink UNION ALL
SELECT CAST(NULL AS VARCHAR(15)) AS Sleep, CAST(NULL AS VARCHAR(15)) AS Food, 'Beer' AS Drink
) d ORDER BY NEWID()
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
September 20, 2010 at 5:28 am
Poodle-cat.
September 20, 2010 at 6:53 am
Brandie Tarvin (9/20/2010)
Poodle-cat.
Well, which is it?
September 20, 2010 at 8:28 am
dbowlin (9/20/2010)
Brandie Tarvin (9/20/2010)
Poodle-cat.Well, which is it?
Yes. @=)
Our cat got shaved for surgery, the entire torso. Legs, tail, and head still have fur. Hence: Poodle-cat.
It's very fun. She's not amused, but we are.
September 20, 2010 at 8:36 am
Brandie Tarvin (9/20/2010)
dbowlin (9/20/2010)
Brandie Tarvin (9/20/2010)
Poodle-cat.Well, which is it?
Yes. @=)
Our cat got shaved for surgery, the entire torso. Legs, tail, and head still have fur. Hence: Poodle-cat.
It's very fun. She's not amused, but we are.
Die her fur pink too!!
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
September 20, 2010 at 8:36 am
Brandie Tarvin (9/20/2010)
dbowlin (9/20/2010)
Brandie Tarvin (9/20/2010)
Poodle-cat.Well, which is it?
Yes. @=)
Our cat got shaved for surgery, the entire torso. Legs, tail, and head still have fur. Hence: Poodle-cat.
It's very fun. She's not amused, but we are.
They hate having their appearance changed. They loathe being laughed at even more.
You ratbag, Brandie! But she will have her revenge, you know that, don't you? When you're least expecting it, in two or three weeks' time...something like a little present in your slippers. And not from outside either π Oh yes.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
September 20, 2010 at 8:37 am
12
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
September 20, 2010 at 8:40 am
Late
September 20, 2010 at 8:46 am
Chris Morris-439714 (9/20/2010)
Brandie Tarvin (9/20/2010)
dbowlin (9/20/2010)
Brandie Tarvin (9/20/2010)
Poodle-cat.Well, which is it?
Yes. @=)
Our cat got shaved for surgery, the entire torso. Legs, tail, and head still have fur. Hence: Poodle-cat.
It's very fun. She's not amused, but we are.
They hate having their appearance changed. They loathe being laughed at even more.
You ratbag, Brandie! But she will have her revenge, you know that, don't you? When you're least expecting it, in two or three weeks' time...something like a little present in your slippers. And not from outside either π Oh yes.
Cruel cruel.
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
September 20, 2010 at 9:11 am
WOTD - Nutrition
Joe
September 20, 2010 at 10:04 am
crookj (9/20/2010)
WOTD - Nutrition
I counter your healthiness with CHOCOLATE!
September 20, 2010 at 10:26 am
Pheasant death....had a great hunt this weekend with a bunch of good friends. Shot a bunch of birds, clays, high-powers, and blew some stuff up.....video/pics on my facebook. Good weekend getaway.
September 20, 2010 at 2:05 pm
John Rowan (9/20/2010)
Pheasant death....had a great hunt this weekend with a bunch of good friends. Shot a bunch of birds, clays, high-powers, and blew some stuff up.....video/pics on my facebook. Good weekend getaway.
I could use something like that - time to go blow something up.
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
September 20, 2010 at 2:34 pm
CirquedeSQLeil (9/20/2010)
John Rowan (9/20/2010)
Pheasant death....had a great hunt this weekend with a bunch of good friends. Shot a bunch of birds, clays, high-powers, and blew some stuff up.....video/pics on my facebook. Good weekend getaway.I could use something like that - time to go blow something up.
We shot some exploding targets...pretty cool stuff. Tannerite.
Viewing 15 posts - 2,776 through 2,790 (of 21,190 total)
You must be logged in to reply to this topic. Login to reply