Neil Burton

Forum Replies Created

Viewing 15 posts - 931 through 945 (of 1,251 total)

RE: Today's Random Word!

SQLRNNR (9/10/2014)
Sean Lange (9/10/2014)
SQLRNNR (9/10/2014)
Sean Lange (9/10/2014)
Ed Wagner (9/10/2014)
whereisSQL? (9/10/2014)
Sean Lange (9/10/2014)
Ed Wagner (9/10/2014)
djj (9/10/2014)
Telephone
Telegraph
Pony Express
History
Lessons Learned
and promptly forgotten so we can repeat ourselves.
Is that old age or selective learning?
Both...
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 11, 2014 at 4:04 am

#1744678
RE: Convert string to Date

Try this
set dateformat dmy
declare @Date varchar(max) = 'Fri 14/01/2009'
declare @processed date= reverse(left(reverse(@date),10))
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 5, 2014 at 9:05 am

#1743539
RE: Today's Random Word!

TomThomson (9/5/2014)
Ed Wagner (9/5/2014)
BWFC (9/5/2014)
TomThomson (9/4/2014)
Ed Wagner (9/4/2014)
djj (9/4/2014)
Ed Wagner (9/4/2014)
Revenant (9/4/2014)
SQLRNNR (9/4/2014)
silver
spoon
Feed
Qats
Granola
Museli
Sawdust 🙂
Project
Projectile
Pork chop
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 5, 2014 at 6:11 am

#1743489
RE: Today's Random Word!

TomThomson (9/4/2014)
Ed Wagner (9/4/2014)
djj (9/4/2014)
Ed Wagner (9/4/2014)
Revenant (9/4/2014)
SQLRNNR (9/4/2014)
silver
spoon
Feed
Qats
Granola
Museli
Sawdust 🙂
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 5, 2014 at 1:50 am

#1743427
RE: Getting Started Question...

Grant Fritchey (9/4/2014)
BWFC (9/4/2014)
Grant Fritchey (9/4/2014)
The hardest thing standing between you and a job is not knowledge or a particular course. The hardest thing is experience. Few companies have entry...
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 4, 2014 at 6:55 am

#1743180
RE: Getting Started Question...

Grant Fritchey (9/4/2014)
The hardest thing standing between you and a job is not knowledge or a particular course. The hardest thing is experience. Few companies have entry level data professional...
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 4, 2014 at 6:20 am

#1743165
RE: Are the posted questions getting worse?

Stuart Davies (9/3/2014)
BWFC (9/3/2014)
Has anybody out there got any experience with Serif WebPlus x5?
Sadly yes - but only in an evaluation way. From memory you have to tie into their...
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 4, 2014 at 12:54 am

#1743098
RE: Are the posted questions getting worse?

Has anybody out there got any experience with Serif WebPlus x5?
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 3, 2014 at 1:17 pm

#1742975
RE: Today's Random Word!

Ed Wagner (9/2/2014)
SQLRNNR (9/2/2014)
gnocchi
Pasta
Pizza
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 3, 2014 at 2:04 am

#1742685
RE: Today's Random Word!

Valour
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 2, 2014 at 7:47 am

#1742448
RE: Today's Random Word!

djj (8/29/2014)
SQLRNNR (8/28/2014)
jaded
forgotten
Realms
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 2, 2014 at 3:01 am

#1742333
RE: Hierarchial Query

CELKO (9/1/2014)
People don't mind helping with homework but you'll find you're likely to get a better response if you post what you've already tried rather than just asking for...
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 2, 2014 at 1:18 am

#1742308
RE: Trimming Last 3 Numbers from some Records

Will the records always have a space in them and will it always be three numbers?
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 1, 2014 at 1:35 am

#1742162
RE: Hierarchial Query

Thanks again.
Next question 🙂 Can you post your table definitions please? There are some column names in the code that don't match what you originally posted. And, looking at...
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 29, 2014 at 5:07 am

#1741848
RE: Hierarchial Query

Thanks Peter. Could you post the code you've tried please?
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 29, 2014 at 4:46 am

#1741846

Viewing 15 posts - 931 through 945 (of 1,251 total)