Neil Burton

Forum Replies Created

Viewing 15 posts - 1,186 through 1,200 (of 1,251 total)

RE: Stored Proc And View Giving Different Results

ChrisM@Work (1/31/2014)
You might get some performance lift by jigging around with your filters. If you're going down this route then do take on board Gail's comments about DISTINCT. You might...
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 7:47 am

#1685060
RE: Today's Random Word!

Ed Wagner (1/31/2014)
Jeff Moden (1/30/2014)
Ed Wagner (1/30/2014)
Luis Cazares (1/30/2014)
Jeff Moden (1/30/2014)
"JOCC BOOSTR" (pronounced "jock booster")
Definition:
Justification Of Crap Code Based Only On Small Table Requirements
🙂
Everywhere
Pervasive
Infectious
Pandamic
Endemic
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 6:28 am

#1685031
RE: Stored Proc And View Giving Different Results

No, I mean the difference in row counts between the procedure and view, the problem that we're trying to solve.
Of course you did, sorry, conference call brain fry.
There is no...
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 6:11 am

#1685015
RE: Stored Proc And View Giving Different Results

GilaMonster (1/31/2014)
Can't see anything obvious (other than multiple unnecessary DISTINCTs)
Is the difference in rowcount consistent?
If you mean 'is the difference in ServiceDays and AverageServiceDays the same every time' then yes....
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 4:25 am

#1684985
RE: Stored Proc And View Giving Different Results

Fair enough, although I'm a little hurt you don't trust me.... 🙂
The code to create the dashboard with the proc
set transaction isolation level read uncommitted
set dateformat ymd
select distinct
OrderType =
case...
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 3:41 am

#1684973
RE: Stored Proc And View Giving Different Results

I've attached the code now. I've had to do a bit of obfuscation, which I hope doesn't hide the logic. The organisation I work for is quite high...
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 3:29 am

#1684968
RE: Today's Random Word!

Kurt W. Zimmerman (1/28/2014)
Ed Wagner (1/28/2014)
L' Eomot Inversé (1/28/2014)
crookj (1/28/2014)
Ed Wagner (1/28/2014)
BWFC (1/28/2014)
Drink
Restaurant
Jocko's Steak House
Rib Eye Steak
Medium rare
à point
Blue
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 29, 2014 at 1:32 am

#1684178
RE: Today's Random Word!

Drink
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 28, 2014 at 1:49 am

#1683820
RE: Today's Random Word!

L' Eomot Inversé (1/24/2014)
Ed Wagner (1/23/2014)
BWFC (1/23/2014)
JAZZ Master (1/22/2014)
Revenant (1/22/2014)
Ed Wagner (1/22/2014)
SQLRNNR (1/22/2014)
sim
City
bestseller
novel
New
Clean
Sterile
Aseptic
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 27, 2014 at 2:02 am

#1683449
RE: Concatenate? Coalesce? IsNull?

Hi Sean
I've had a tinker with my proc and using the CTE approach works just as quickly as temp tables when using my method to create the combined column. ...
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 24, 2014 at 4:14 am

#1683074
RE: Concatenate? Coalesce? IsNull?

Thanks Sean. I did try using CTE's when I was testing but oh boy did it slow down. I'd forgotten about STUFF, I'm very new to SQL 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

January 23, 2014 at 8:14 am

#1682817
RE: Today's Random Word!

JAZZ Master (1/22/2014)
Revenant (1/22/2014)
Ed Wagner (1/22/2014)
SQLRNNR (1/22/2014)
sim
City
bestseller
novel
New
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 23, 2014 at 1:18 am

#1682651
RE: Today's Random Word!

Ed Wagner (1/17/2014)
OCTom (1/17/2014)
SQLRNNR (1/17/2014)
Rockford
files
Paths
Roads
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 20, 2014 at 1:25 am

#1681446
RE: Today's Random Word!

Ed Wagner (1/16/2014)
SQLRNNR (1/16/2014)
JAZZ Master (1/16/2014)
Revenant (1/16/2014)
sing4you (1/16/2014)
crookj (1/16/2014)
Ed Wagner (1/16/2014)
SQLRNNR (1/16/2014)
Ed Wagner (1/16/2014)
BWFC (1/16/2014)
Ed Wagner (1/15/2014)
crookj (1/15/2014)
WOTD - bletcherous
Code
Bloat
Fix (as in make efficient)
diet
Coke
Soda
Scotch
naked (as in 'We Scots like...
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 17, 2014 at 1:14 am

#1680976
RE: Today's Random Word!

Ed Wagner (1/15/2014)
crookj (1/15/2014)
WOTD - bletcherous
Code
Bloat
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 16, 2014 at 1:02 am

#1680536

Viewing 15 posts - 1,186 through 1,200 (of 1,251 total)