Viewing 15 posts - 1,306 through 1,320 (of 1,493 total)
Ed Wagner (8/13/2014)
crookj (8/13/2014)
Ed Wagner (8/13/2014)
Stuart Davies (8/13/2014)
whereisSQL? (8/12/2014)
SQLRNNR (8/12/2014)
Revenant (8/12/2014)
Ed Wagner (8/11/2014)
djj (8/11/2014)
SQLRNNR (8/11/2014)
crookj (8/11/2014)
Ed Wagner (8/11/2014)
SQLRNNR (8/11/2014)
charitableDonation
Time (the most valuable asset)
self
serving
Others
Otters
oyster
world
cup
Quart
Pint
Beer
Garden
August 13, 2014 at 7:07 am
monkeyflavours (8/12/2014)
I’m scratching my head with a bit of script. Why would the below choose a unique set of records from one table to put...
August 12, 2014 at 6:54 am
SQLRNNR (8/11/2014)
crookj (8/11/2014)
Ed Wagner (8/11/2014)
SQLRNNR (8/11/2014)
charitableDonation
Time (the most valuable asset)
self
serving
August 11, 2014 at 8:39 am
Ed Wagner (8/11/2014)
Stuart Davies (8/11/2014)
Revenant (8/11/2014)
Ed Wagner (8/9/2014)
TomThomson (8/9/2014)
SQLRNNR (8/8/2014)
CompostPotting
Growing
Nurturing
Caring
Sharing
Giving
August 11, 2014 at 5:49 am
Ed Wagner (8/8/2014)
SQLRNNR (8/8/2014)
Ed Wagner (8/8/2014)
sing4you (8/8/2014)
Ed Wagner (8/8/2014)
TomThomson (8/8/2014)
Ed Wagner (8/8/2014)
Revenant (8/7/2014)
Ed Wagner (8/7/2014)
SQLRNNR (8/7/2014)
djj (8/7/2014)
SQLRNNR (8/7/2014)
springsbed
squeak
Brakes
Strakes
Hull (Thanks...I had to look up the meaning of the word and it's...
August 8, 2014 at 12:03 pm
Ed Wagner (8/7/2014)
SQLRNNR (8/7/2014)
Ed Wagner (8/7/2014)
TomThomson (8/7/2014)
SQLRNNR (8/6/2014)
Sean Lange (8/6/2014)
Ed Wagner (8/6/2014)
TomThomson (8/6/2014)
Ed Wagner (8/6/2014)
SQLRNNR (8/6/2014)
Ed Wagner (8/6/2014)
djj (8/6/2014)
Ed Wagner (8/6/2014)
SQLRNNR (8/5/2014)
EL Jerry (8/5/2014)
Revenant (8/5/2014)
YellowPages
Eight
Kilobytes
Kilo Class
Nautilus
Nucular
Attack
Defense
Self-Defense
nunchucks
self-offense
masochism
Strange
love
Hope
Abandon
August 7, 2014 at 8:46 am
Ed Wagner (8/6/2014)
SQLRNNR (8/5/2014)
EL Jerry (8/5/2014)
Revenant (8/5/2014)
YellowPages
Eight
Kilobytes
Kilo Class
August 6, 2014 at 5:45 am
Found this from Paul S. Randal of SQLskills.com:
"Here's the rule: if my 14-yr old smart daughter could find the answer on Google from your question, you'd shouldn't ask or send...
August 4, 2014 at 10:16 am
Gazareth (8/4/2014)
BWFC (8/4/2014)
August 4, 2014 at 5:31 am
whereisSQL? (7/30/2014)
Ed Wagner (7/30/2014)
TomThomson (7/30/2014)
SQLRNNR (7/30/2014)
Ed Wagner (7/30/2014)
Stuart Davies (7/30/2014)
SQLRNNR (7/29/2014)
aardvarkDigger
Hunting (for antiques)
Pecheur
é or ê?
Tomato
ketchup
hot dog
July 30, 2014 at 1:24 pm
Keith Tate (7/30/2014)
Looks like you just missed the second join criteria (C1 Firstname = M1 Name 2). I would also think about recording first and middle name separately in Check2.
Thank...
July 30, 2014 at 9:03 am
I did come up with this:
SELECT DISTINCT C1.IDX
, C2.C2FirstName
, C1.C1FirstName
, CASE WHEN CHARINDEX(' ',C2.C2FirstName) > 0...
July 30, 2014 at 8:49 am
crmitchell (7/30/2014)
July 30, 2014 at 4:45 am
Lookup table no problem. Been there done that.
I was looking for information to populate the lookup table.
Thanks for the nickname hint. One problem I have with internet searches...
July 29, 2014 at 1:24 pm
Viewing 15 posts - 1,306 through 1,320 (of 1,493 total)