Viewing 15 posts - 6,691 through 6,705 (of 9,399 total)
whereisSQL? (1/16/2015)
Ed Wagner (1/16/2015)
crookj (1/16/2015)
Ed Wagner (1/16/2015)
djj (1/16/2015)
Ed Wagner (1/16/2015)
TomThomson (1/16/2015)
SQLRNNR (1/16/2015)
divisionmultiplication
addition
subtraction
Exponent
Percent
Discount
Sale
Volume
January 16, 2015 at 1:20 pm
crookj (1/16/2015)
Ed Wagner (1/16/2015)
djj (1/16/2015)
Ed Wagner (1/16/2015)
TomThomson (1/16/2015)
SQLRNNR (1/16/2015)
divisionmultiplication
addition
subtraction
Exponent
Percent
Discount
January 16, 2015 at 12:07 pm
Jeff Moden (1/16/2015)
halifaxdal (1/16/2015)
Jeff Moden (1/16/2015)
halifaxdal (1/16/2015)
no way i know of to ignore errors, you have to explicitly use LEFT functions in the SELECT or something to work around this...
January 16, 2015 at 11:58 am
djj (1/16/2015)
Ed Wagner (1/16/2015)
TomThomson (1/16/2015)
SQLRNNR (1/16/2015)
divisionmultiplication
addition
subtraction
Exponent
January 16, 2015 at 11:52 am
TomThomson (1/16/2015)
SQLRNNR (1/16/2015)
divisionmultiplication
addition
January 16, 2015 at 11:20 am
whereisSQL? (1/16/2015)
Ed Wagner (1/16/2015)
crookj (1/16/2015)
Ed Wagner (1/16/2015)
djj (1/16/2015)
Ed Wagner (1/16/2015)
BWFC (1/16/2015)
Stuart Davies (1/16/2015)
Ed Wagner (1/15/2015)
djj (1/15/2015)
Ed Wagner (1/15/2015)
SQLRNNR (1/15/2015)
Ed Wagner (1/15/2015)
Taxes@$!%#$!^#
Gouge
Excess
Spend
Thrift
Store
Food
Drink
Meal
Last
First
Race
Win
January 16, 2015 at 7:41 am
crookj (1/16/2015)
Ed Wagner (1/16/2015)
djj (1/16/2015)
Ed Wagner (1/16/2015)
BWFC (1/16/2015)
Stuart Davies (1/16/2015)
Ed Wagner (1/15/2015)
djj (1/15/2015)
Ed Wagner (1/15/2015)
SQLRNNR (1/15/2015)
Ed Wagner (1/15/2015)
Taxes@$!%#$!^#
Gouge
Excess
Spend
Thrift
Store
Food
Drink
Meal
Last
First
January 16, 2015 at 7:26 am
djj (1/16/2015)
Ed Wagner (1/16/2015)
BWFC (1/16/2015)
Stuart Davies (1/16/2015)
Ed Wagner (1/15/2015)
djj (1/15/2015)
Ed Wagner (1/15/2015)
SQLRNNR (1/15/2015)
Ed Wagner (1/15/2015)
Taxes@$!%#$!^#
Gouge
Excess
Spend
Thrift
Store
Food
Drink
Meal
January 16, 2015 at 6:21 am
Brandie Tarvin (1/16/2015)
GilaMonster (1/15/2015)
Sean Lange (1/15/2015)
EXISTS(select 1
is way faster than just select *. I know Gail has an article...
January 16, 2015 at 5:36 am
GilaMonster (1/15/2015)
Easiest way to prove, other than with tests, is to show that SQL completely ignores the column list in an exists.
WHERE EXISTS (SELECT 1/0 FROM ....)
I've always used SELECT...
January 16, 2015 at 5:27 am
Michael_Garrison (1/16/2015)
Good question. What I am trying to figure out is how Koen is ALWAYS the first to reply to QoD discussions?
I'm not sure he sleeps. 😉 Nice...
January 16, 2015 at 5:19 am
BWFC (1/16/2015)
Stuart Davies (1/16/2015)
Ed Wagner (1/15/2015)
djj (1/15/2015)
Ed Wagner (1/15/2015)
SQLRNNR (1/15/2015)
Ed Wagner (1/15/2015)
Taxes@$!%#$!^#
Gouge
Excess
Spend
Thrift
Store
Food
January 16, 2015 at 5:14 am
djj (1/15/2015)
Ed Wagner (1/15/2015)
SQLRNNR (1/15/2015)
Ed Wagner (1/15/2015)
Taxes@$!%#$!^#
Gouge
Excess
Spend
January 15, 2015 at 11:18 am
SQLRNNR (1/15/2015)
Ed Wagner (1/15/2015)
Taxes@$!%#$!^#
Gouge
January 15, 2015 at 8:48 am
djj (1/15/2015)
Ed Wagner (1/15/2015)
BWFC (1/15/2015)
Ed Wagner (1/15/2015)
ChrisM@Work (1/15/2015)
Ed Wagner (1/15/2015)
ChrisM@Work (1/15/2015)
BWFC (1/15/2015)
richxs (1/15/2015)
Giraffe DBA (1/14/2015)
SQLRNNR (1/14/2015)
Ed Wagner (1/14/2015)
djj (1/14/2015)
BWFC (1/14/2015)
Ed Wagner (1/14/2015)
Stuart Davies (1/14/2015)
TomThomson (1/13/2015)
Ed Wagner (1/13/2015)
SQLRNNR (1/13/2015)
regexPattern
Match
Point
Edge
Bono
Sonny
Cher
Babe (i've got...
January 15, 2015 at 6:59 am
Viewing 15 posts - 6,691 through 6,705 (of 9,399 total)