Viewing 15 posts - 601 through 615 (of 1,243 total)
rodjkidd (9/15/2015)
BWFC (9/15/2015)
rodjkidd (9/14/2015)
BWFC (9/11/2015)
BWFC (9/11/2015)
September 15, 2015 at 2:33 am
rodjkidd (9/14/2015)
BWFC (9/11/2015)
BWFC (9/11/2015)
September 15, 2015 at 1:45 am
Reported as spam
September 14, 2015 at 3:30 am
BWFC (9/11/2015)
September 11, 2015 at 7:03 am
BL0B_EATER (9/11/2015)
Ed Wagner (9/11/2015)
Alvin Ramard (9/10/2015)
Lynn Pettis (9/10/2015)
Alvin Ramard (9/10/2015)
Lynn Pettis (9/10/2015)
September 11, 2015 at 6:36 am
Ed Wagner (9/11/2015)
Eirikur Eiriksson (9/11/2015)
anthony.green (9/11/2015)
whereisSQL? (9/10/2015)
Ed Wagner (9/10/2015)
DonlSimpson (9/10/2015)
Ed Wagner (9/10/2015)
djj (9/10/2015)
Ed Wagner (9/10/2015)
whereisSQL? (9/10/2015)
Luis Cazares (9/10/2015)
UniverseHe-Man
Conan
Sword
Katana
Samurai
Shogun
Shaolin
Monastery
Hermetic
Seal
Wax
September 11, 2015 at 5:46 am
Does anybody know if SQL Relay Huddersfield is still going ahead? I had an email this morning and it wasn't listed as one of the venues. It's still...
September 11, 2015 at 2:04 am
Eirikur Eiriksson (9/10/2015)
Stuart Davies (9/10/2015)
Ed Wagner (9/9/2015)
djj (9/9/2015)
Ed Wagner (9/9/2015)
DonlSimpson (9/9/2015)
Luis Cazares (9/9/2015)
Ed Wagner (9/9/2015)
crookj (9/9/2015)
Jim_K (9/9/2015)
ZZartin (9/9/2015)
eccentricDBA (9/9/2015)
BWFC (9/9/2015)
Eirikur Eiriksson (9/9/2015)
whereisSQL? (9/9/2015)
ClassyGlossy
Magazine
cartridge
Cartilage
Shark
Jaws
Sea
World
Globe
Travel
Lodge
Cast Iron
guarantee
Warranty
Extended
September 10, 2015 at 12:53 am
Eirikur Eiriksson (9/9/2015)
whereisSQL? (9/9/2015)
ClassyGlossy
Magazine
September 9, 2015 at 8:31 am
andrew gothard (9/9/2015)
BWFC (9/8/2015)
A correctly formed postcode can be 7 or 8 characters - eg SW1A 4WW so change RIGHT(PostalCode, 7) to RIGHT(PostalCode, 8) and LTRIM the result
Postcodes can be...
September 9, 2015 at 3:23 am
I don't know what your data looks like but that will only work for an eight character postcode. If you take the rightmost eight characters of your string you will...
September 9, 2015 at 3:00 am
SELECT
ltrim(right(postalcode,charindex(' ',reverse(postalcode),PATINDEX('% %',reverse(postalcode))+1)))
FROM yourdata
I've tested this over 14500 county+[space]+postcode combinations and the only ones it didn't work on were cases where there was no space in the...
September 8, 2015 at 8:03 am
A correctly formed postcode can be 7 or 8 characters - eg SW1A 4WW so change RIGHT(PostalCode, 7) to RIGHT(PostalCode, 8) and LTRIM the result
Postcodes can be 6,7 or 8...
September 8, 2015 at 7:30 am
Pack_Star (9/8/2015)
Most of the records in this column are correct i.e. NN4 0NB (two strings separated with a space), Then occasionally I return corrupt records i.e. Derbyshire S42 5BX (three...
September 8, 2015 at 7:02 am
Eirikur Eiriksson (8/27/2015)
Thank you for this interesting question Hugo.😎
Slightly taken aback seeing the overall results though
Correct answers:6%Incorrect answers:94%
I suspect that's got something to do with how people have researched this....
August 27, 2015 at 2:35 am
Viewing 15 posts - 601 through 615 (of 1,243 total)