Neil Burton

Forum Replies Created

Viewing 15 posts - 991 through 1,005 (of 1,251 total)

RE: Identical XML

Thanks MM, I had a feeling the answer was going to be something like that. What is now the fail-over used to be live so we did create reports...
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

June 24, 2014 at 1:00 am

#1724236
RE: Identical XML

This is bad form I know but can anybody help? Has anybody seen anything like this before? We're looking at a bit of investment and the answer to this question...
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

June 23, 2014 at 3:23 pm

#1724208
RE: Effective Max

Igor Micev (6/21/2014)
Simple maths, thanks!
Simple maths + basic misunderstanding = got it wrong :blush:
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

June 23, 2014 at 1:25 am

#1723905
RE: Today's Random Word!

Magnetic
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

June 22, 2014 at 3:47 am

#1723840
RE: Today's Random Word!

Atheist
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

June 20, 2014 at 8:09 am

#1723614
RE: Today's Random Word!

BWFC (6/20/2014)
BWFC (6/20/2014)
thomashohner (6/19/2014)
Spammers
Spam
Spam
Spam
Sorry, couldn't resist :Whistling:
Python
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

June 20, 2014 at 1:11 am

#1723476
RE: Today's Random Word!

BWFC (6/20/2014)
thomashohner (6/19/2014)
Spammers
Spam
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

June 20, 2014 at 1:09 am

#1723475
RE: Today's Random Word!

thomashohner (6/19/2014)
Spammers
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

June 20, 2014 at 1:09 am

#1723474
RE: No Files For You

Sean Pearce (6/19/2014)
mod: removed dead link
Do you mind if I borrow that?
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

June 19, 2014 at 6:37 am

#1723202
RE: Today's Random Word!

Method
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

June 19, 2014 at 1:13 am

#1723081
RE: Reading, Writing, and Riskmetic

I got one of Andy's right!!!!!!!
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

June 19, 2014 at 1:11 am

#1723079
RE: No Files For You

TomThomson (6/18/2014)
BWFC (6/18/2014)
I disagree there. It doesn't say that all on site databases are 2012, it says that uses 2012. That doesn't preclude there being...
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

June 18, 2014 at 1:01 pm

#1722950
RE: display all data from row 1 but include sum total of all rows amount column in data set

SELECT distinct
q.Description
,SUM(q.Amount) OVER (PARTITION BY q.Description)
FROM #Question q
It might be worth you trying to create some sample data that's closer to what you actually have. You can do...
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

June 18, 2014 at 8:26 am

#1722827
RE: No Files For You

And another thing!!!
the cloud is the more likely given that the company is progressive enought to have everything on site running SQL 2012
The company I work for is constantly employing,...
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

June 18, 2014 at 8:11 am

#1722821
RE: display all data from row 1 but include sum total of all rows amount column in data set

mattech06 (6/18/2014)
Actually guys, the old classic, it worked on that specific example but not on the full data set.
So a better example would be using a table with ..
CREATE TABLE...
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

June 18, 2014 at 8:03 am

#1722812

Viewing 15 posts - 991 through 1,005 (of 1,251 total)