Viewing 15 posts - 601 through 615 (of 1,245 total)
whereisSQL? (9/15/2015)
Ray K (9/15/2015)
Ed Wagner (9/15/2015)
Eirikur Eiriksson (9/15/2015)
djj (9/15/2015)
Ed Wagner (9/15/2015)
anthony.green (9/15/2015)
Ed Wagner (9/14/2015)
InspireEureka
Vacuum
tube
Commute
Traffic
Jam
Jelly
Roll
September 15, 2015 at 7:36 am
Please tell me it's not just me who saw the title of today's editorial and immediately replied mentally with 'yes, you're a good developer.'
Must.Grow.Up
September 15, 2015 at 2:38 am
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
Viewing 15 posts - 601 through 615 (of 1,245 total)