Neil Burton

Forum Replies Created

Viewing 15 posts - 1,171 through 1,185 (of 1,251 total)

RE: Number of Records Affected

Eugene Elutin (2/6/2014)
BWFC (2/6/2014)
jayoub (2/6/2014)
I would like to know how to run an update or delete query and have a chance to commit or not. Here is the issue....
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

February 6, 2014 at 9:00 am

#1686656
RE: Number of Records Affected

jayoub (2/6/2014)
I would like to know how to run an update or delete query and have a chance to commit or not. Here is the issue. When I...
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

February 6, 2014 at 8:48 am

#1686646
RE: Today's Random Word!

Sean Lange (2/6/2014)
Ed Wagner (2/6/2014)
SQLRNNR (2/6/2014)
BWFC (2/6/2014)
SQLRNNR (2/6/2014)
Kurt W. Zimmerman (2/6/2014)
BWFC (2/6/2014)
Ed Wagner (2/6/2014)
L' Eomot Inversé (2/6/2014)
BWFC (2/6/2014)
Animated
Cartoon
Bugs
Bunny
Fudd (Elmer J)
Wabbit
Won...wabbit, won wabbit, won, won, won 🙂
Kill the wabbit
It's wabbit season
Duck...
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

February 6, 2014 at 8:08 am

#1686623
RE: Today's Random Word!

SQLRNNR (2/6/2014)
Kurt W. Zimmerman (2/6/2014)
BWFC (2/6/2014)
Ed Wagner (2/6/2014)
L' Eomot Inversé (2/6/2014)
BWFC (2/6/2014)
Animated
Cartoon
Bugs
Bunny
Fudd (Elmer J)
Wabbit
Won...wabbit, won wabbit, won, won, won 🙂
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

February 6, 2014 at 7:58 am

#1686615
RE: Today's Random Word!

Ed Wagner (2/6/2014)
L' Eomot Inversé (2/6/2014)
BWFC (2/6/2014)
Animated
Cartoon
Bugs
Bunny
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

February 6, 2014 at 5:32 am

#1686542
RE: Today's Random Word!

Animated
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

February 6, 2014 at 1:11 am

#1686470
RE: Show All Rows When a Parameter is Null

Bill Talada (2/5/2014)
Your easiest solution might be to do this simple change. If a parameter is given a value, then a subset of rows will be returned. If...
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

February 5, 2014 at 8:10 am

#1686214
RE: Today's Random Word!

Kurt W. Zimmerman (2/5/2014)
Ed Wagner (2/5/2014)
BWFC (2/5/2014)
SQLRNNR (2/4/2014)
toke
Draw
Shoot
Skeet
Clay
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

February 5, 2014 at 7:07 am

#1686192
RE: Today's Random Word!

SQLRNNR (2/4/2014)
toke
Draw
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

February 5, 2014 at 1:25 am

#1686109
RE: Today's Random Word!

Beyond
Infinity 🙂
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

February 4, 2014 at 1:12 am

#1685749
RE: Stored Proc And View Giving Different Results

GilaMonster (2/3/2014)
BWFC (2/3/2014)
I'm personally surprised not one of the auditors has said something like 'about these nolocks...'
No, they won't. Most aren't technical and won't have any idea of the implications....
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

February 3, 2014 at 7:00 am

#1685470
RE: Stored Proc And View Giving Different Results

GilaMonster (2/3/2014)
BWFC (2/3/2014)
I don't think we have much in the way of blocking problems, although it's not something that would necessarily come to my attention if we did.
If you have...
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

February 3, 2014 at 6:39 am

#1685459
RE: Stored Proc And View Giving Different Results

I don't think we have much in the way of blocking problems, although it's not something that would necessarily come to my attention if we did. My boss or...
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

February 3, 2014 at 5:58 am

#1685447
RE: Stored Proc And View Giving Different Results

Jeffrey Williams 3188 (1/31/2014)
Remove the Distinct in the view definition - that is going to eliminate rows from the grouping that are actually included in the procedure.
The distinct will 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

February 3, 2014 at 5:21 am

#1685437
RE: Stored Proc And View Giving Different Results

ChrisM@Work (1/31/2014)
That's okay, it was always going to be a long shot with no sample data blah blah.
I hope you can take away a few ideas from it though,...
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

January 31, 2014 at 10:43 am

#1685147

Viewing 15 posts - 1,171 through 1,185 (of 1,251 total)