Neil Burton

Forum Replies Created

Viewing 15 posts - 946 through 960 (of 1,251 total)

RE: Hierarchial Query

Hi Peter,
welcome to the forums. If you have a read of this [/url] article, it'll make it much easier to see what you want. All those 1's...
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 3:06 am

#1741831
RE: Today's Random Word!

ChrisM@Work (8/28/2014)
Ed Wagner (8/28/2014)
ChrisM@Work (8/28/2014)
TomThomson (8/28/2014)
Ed Wagner (8/28/2014)
BWFC (8/28/2014)
TomThomson (8/27/2014)
Ed Wagner (8/27/2014)
crookj (8/27/2014)
Ed Wagner (8/27/2014)
BWFC (8/27/2014)
Punched tape
Cards (remember the stack that got dropped?)
Chad
Election
Florida
Keys
Alligators
Everglades
Aviator shades
Fighter Pilot
Pitot tube
Airspeed
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 28, 2014 at 6:20 am

#1741613
RE: Today's Random Word!

TomThomson (8/27/2014)
Ed Wagner (8/27/2014)
crookj (8/27/2014)
Ed Wagner (8/27/2014)
BWFC (8/27/2014)
Punched tape
Cards (remember the stack that got dropped?)
Chad
Election
Florida
Keys
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 28, 2014 at 5:23 am

#1741597
RE: Today's Random Word!

Punched tape
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, 2014 at 5:32 am

#1741279
RE: PIVOT

sestell1 (8/25/2014)
Does anyone actually use the PIVOT operator?
I find it so limited that I almost always roll my own using GROUP BY and CASE.
I used it for the first time...
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 26, 2014 at 1:20 am

#1740931
RE: Some time Stored Procedure suddenly taking 10 seconds when we called through application.

I also noticed that the OP doesn't mention the normal time it takes to run. It's possible that 10 seconds could actually be an improvement. Things inexplicably running...
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 22, 2014 at 7:30 am

#1740213
RE: Are the posted questions getting worse?

I feel that I should make some mention of this man's birthday today. I think without his work our lives may be very different\easier\harder, delete as appropriate.
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 4, 2014 at 4:38 am

#1734781
RE: Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it?

Carlo Romagnano (8/4/2014)
I read question and answers many times because of high score.
I was searching for the swindle!
But it's only a straightforward basic question.
😀
+1
I thought I knew what 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 4, 2014 at 1:29 am

#1734745
RE: Today's Random Word!

Revenant (7/30/2014)
SQLRNNR (7/30/2014)
Sean Lange (7/30/2014)
Ed Wagner (7/30/2014)
SQLRNNR (7/30/2014)
djj (7/30/2014)
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)
aardvark
Digger
Hunting (for antiques)
Pecheur
é or ê?
Tomato
ketchup
hot dog
breakfast
Dinner
Bacon
Pork Belly
futures
Markets
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 31, 2014 at 1:33 am

#1733939
RE: One a Week

Gary Varga (7/30/2014)
BWFC (7/30/2014)
I've even heard that some pubs allow self catering option.
My sister (actually my mum) did the catering for my nephew's Christening do herself. The pub...
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, 2014 at 5:31 am

#1733527
RE: One a Week

I've even heard that some pubs allow self catering option.
My sister (actually my mum) did the catering for my nephew's Christening do herself. The pub made a nominal...
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, 2014 at 2:38 am

#1733490
RE: Today's Random Word!

Legs
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 29, 2014 at 4:49 am

#1733135
RE: When Does Minimum not Mean Minimum?

Grant Fritchey (7/23/2014)
Thanks for posting your solution. Now when anyone searches for this same problem and finds it, they'll know what you did to solve it. That really helps.
If it...
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 23, 2014 at 5:28 am

#1731701
RE: When Does Minimum not Mean Minimum?

I've solved it and it was pretty obvious in the end. My where predicate was excluding the rows with the earlier times from the query because I was only...
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 23, 2014 at 3:28 am

#1731673
RE: Taking long time for a single table execution

Do you know anything about your hardware set up? With the best will in the world, it's going to take a lot longer to run on a 386 than...
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 22, 2014 at 5:33 am

#1731376

Viewing 15 posts - 946 through 960 (of 1,251 total)