Neil Burton

Forum Replies Created

Viewing 15 posts - 616 through 630 (of 1,251 total)

RE: Today's Random Word!

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)
Classy
Glossy
Magazine
cartridge
Cartilage
Shark
Jaws
Sea
World
Globe
Travel
Lodge
Cast Iron
guarantee
Warranty
Extended
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

September 10, 2015 at 12:53 am

#1825608
RE: Today's Random Word!

Eirikur Eiriksson (9/9/2015)
whereisSQL? (9/9/2015)
Classy
Glossy
Magazine
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

September 9, 2015 at 8:31 am

#1825408
RE: Remove String from column Post Code Field

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...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

September 9, 2015 at 3:23 am

#1825339
RE: Remove String from column Post Code Field

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...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

September 9, 2015 at 3:00 am

#1825335
RE: Remove String from column Post Code Field

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...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

September 8, 2015 at 8:03 am

#1825145
RE: Remove String from column Post Code Field

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...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

September 8, 2015 at 7:30 am

#1825121
RE: Remove String from column Post Code Field

Pack_Star (9/8/2015)
Hi,
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...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

September 8, 2015 at 7:02 am

#1825103
RE: Columnstore Index metadata

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....
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

August 27, 2015 at 2:35 am

#1822676
RE: http://healthrxpuregarcinia.com/prolongz/

Reported as spam
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

August 25, 2015 at 5:30 am

#1822166
RE: Logical File Names

Alvin Ramard (8/3/2015)
Ed Wagner (8/3/2015)
Sean Lange (8/3/2015)
Again lots of complaining. Come on people get over it. The question of the day is intended to provoke some learning. Guess what, as...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

August 3, 2015 at 8:08 am

#1816825
RE: Logical File Names

Sean Lange (8/3/2015)
Again lots of complaining. Come on people get over it. The question of the day is intended to provoke some learning. Guess what, as humans we learn more...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

August 3, 2015 at 8:06 am

#1816822
RE: Logical File Names

TomThomson (8/3/2015)
Anyone who says "this is the most badly put together question I've seen for a long time" has clearly not looked at many Questions of the Day, and the...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

August 3, 2015 at 6:46 am

#1816782
RE: Data Warehouse Basics

Reported as spam.
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

August 3, 2015 at 4:55 am

#1816750
RE: Logical File Names

Not only do none of the answers appear to be correct but the the explanation does not match the options.
The correct answer is Query 2, with the MODIFY FILE option...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

August 3, 2015 at 1:16 am

#1816719
RE: BETWEEN alternative

Have you thought about using <= and >=?
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

July 30, 2015 at 9:00 am

#1816171

Viewing 15 posts - 616 through 630 (of 1,251 total)