|
|
|
|
shelflifers
Member
|
|
|
Joined: 10 Jun 2002
Posts: 18633
Location: Austin, TX
|
| Back to top
|
|
 Posted: 07/18/03 - 13:49 Post subject: I'm avoiding that SQL post...
...like the plague. 
|
|
|
|
|
TriBob
Member
|
|
|
Joined: 29 Aug 2002
Posts: 5771
Location: Lost in Transition
|
| Back to top
|
|
Posted: 07/18/03 - 14:15 Post subject:
DECLARE @shelfie sql_variant
|
|
|
|
|
shelflifers
Member
|
|
|
Joined: 10 Jun 2002
Posts: 18633
Location: Austin, TX
|
| Back to top
|
|
Posted: 07/18/03 - 14:17 Post subject:
eh?
|
|
|
|
|
cherylpf
crazy cat lady
|
|
|
Joined: 14 May 2002
Posts: 17305
|
| Back to top
|
|
Posted: 07/18/03 - 14:31 Post subject:
| TriBob wrote: | | DECLARE @shelfie sql_variant |
I don't know, but I think this explains why I'm avoiding it.
|
|
|
|
|
spongebob
Former FFL Champion
|
|
|
Joined: 15 May 2002
Posts: 3602
|
| Back to top
|
|
Posted: 07/18/03 - 14:39 Post subject:
SELECT COUNT(*) FROM RIFFRAFF WHERE SHELF='FUBBY' ORDER BY ASSCLOWN DESC
|
|
|
|
|
Sandy Cheeks
Member
|
|
|
Joined: 14 May 2002
Posts: 4605
Location: in the city that never sleeps
|
| Back to top
|
|
Posted: 07/18/03 - 14:43 Post subject:
I don't know either, Cheryl, but I have a distinct feeling that this is hilarious.
|
|
|
|
|
cherylpf
crazy cat lady
|
|
|
Joined: 14 May 2002
Posts: 17305
|
| Back to top
|
|
Posted: 07/18/03 - 14:44 Post subject:
| Sandy Cheeks wrote: | | I don't know either, Cheryl, but I have a distinct feeling that this is hilarious. |
No, I finally broke down and checked the SQL thread. Not that funny.
|
|
|
|
|
AlaninTX
Member
|
|
|
Joined: 14 May 2002
Posts: 6582
Location: Austin, Texas
|
| Back to top
|
|
Posted: 07/18/03 - 14:48 Post subject:
I bet the SQL gang can't make this past 2 pages.
|
|
|
|
|
shelflifers
Member
|
|
|
Joined: 10 Jun 2002
Posts: 18633
Location: Austin, TX
|
| Back to top
|
|
Posted: 07/18/03 - 14:55 Post subject:
| Runner X wrote: | | SELECT COUNT(*) FROM RIFFRAFF WHERE SHELF='FUBBY' ORDER BY ASSCLOWN DESC |
Oh, I think I understand it now. And with that understanding comes hurt feelings and bittnerness towards X.  and 
|
|
|
|
|
spongebob
Former FFL Champion
|
|
|
Joined: 15 May 2002
Posts: 3602
|
| Back to top
|
|
Posted: 07/18/03 - 15:07 Post subject:
| shelflifers wrote: | | Runner X wrote: | | SELECT COUNT(*) FROM RIFFRAFF WHERE SHELF='FUBBY' ORDER BY ASSCLOWN DESC |
Oh, I think I understand it now. And with that understanding comes hurt feelings and bittnerness towards X. and |
Not if the COUNT returns zero, Shelf. Not if the COUNT returns zero!
|
|
|
|
|
shelflifers
Member
|
|
|
Joined: 10 Jun 2002
Posts: 18633
Location: Austin, TX
|
| Back to top
|
|
Posted: 07/18/03 - 15:14 Post subject:
| Runner X wrote: | | shelflifers wrote: | | Runner X wrote: | | SELECT COUNT(*) FROM RIFFRAFF WHERE SHELF='FUBBY' ORDER BY ASSCLOWN DESC |
Oh, I think I understand it now. And with that understanding comes hurt feelings and bittnerness towards X. and |
Not if the COUNT returns zero, Shelf. Not if the COUNT returns zero! |
Oh.
(i have no response to this)
|
|
|
|
|
joplus
Member
|
|
|
Joined: 18 Sep 2002
Posts: 128
Location: Tampa, FL
|
| Back to top
|
|
Posted: 07/18/03 - 15:41 Post subject:
select convert(varchar(20), COALESCE(sqlthread.coolness, shelfie.fubbiness)) from riffraffhangout (nolock) where post.original_date > CONVERT(DATETIME, DATEDIFF(DAY, 0, getdate()))
did I forget a paren?
|
|
|
|
|
cherylpf
crazy cat lady
|
|
|
Joined: 14 May 2002
Posts: 17305
|
| Back to top
|
|
Posted: 07/18/03 - 15:44 Post subject:
| joplus wrote: | select convert(varchar(20), COALESCE(sqlthread.coolness, shelfie.fubbiness)) from riffraffhangout (nolock) where post.original_date > CONVERT(DATETIME, DATEDIFF(DAY, 0, getdate()))
did I forget a paren? |
 Did I forget to take some sort of pain reliever...?
|
|
|
|
