Neil Burton

Forum Replies Created

Viewing 15 posts - 1,036 through 1,050 (of 1,251 total)

RE: Weird Join Problem

ChrisM@Work (6/9/2014)
BWFC (6/9/2014)
ChrisM@Work (6/9/2014)
Is there any chance that your original query - the one with the error - had a filter for the comma in the WHERE clause? If you...
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 9, 2014 at 8:41 am

#1720114
RE: Weird Join Problem

ChrisM@Work (6/9/2014)
Is there any chance that your original query - the one with the error - had a filter for the comma in the WHERE clause? If you can answer...
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 9, 2014 at 7:08 am

#1720066
RE: Weird Join Problem

dbalmf (6/9/2014)
I haven't tested this but i think your issue is with the ISNULL in the weird bit. When the name is NULL you set it to None. this does...
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 9, 2014 at 7:05 am

#1720065
RE: Today's Random Word!

Cambodia
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 5, 2014 at 2:08 am

#1719109
RE: Today's Random Word!

Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
JAZZ Master (6/2/2014)
Ed Wagner (6/2/2014)
whereisSQL? (6/2/2014)
Ed Wagner (6/2/2014)
crookj (6/2/2014)
Ed Wagner (6/2/2014)
SQLRNNR (6/2/2014)
science
Math
Algebra
Adademics
College
Expensive
Cheap
Trick
Shame
Embarrass
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 3, 2014 at 1:08 am

#1718425
RE: Today's Random Word!

Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
crookj (6/2/2014)
whereisSQL? (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
crookj (6/2/2014)
Ed Wagner (6/2/2014)
SQLRNNR (6/1/2014)
dickory
Dock
Mouse
Keyboard
Tray
System
Malfunction
Blue Screen
Death
Creeping
Lightning
Bell
Fade
Master (I guess if 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

June 2, 2014 at 8:35 am

#1718229
RE: Making Sense of Statistics

GilaMonster (6/2/2014)
BWFC (6/2/2014)
It seemed logically different from looking up something each time needed it with the subqueries.
But that's not how subqueries behave....
And that's inexperience again. I think it'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

June 2, 2014 at 6:22 am

#1718173
RE: Making Sense of Statistics

GilaMonster (6/2/2014)
BWFC (6/2/2014)
It was just that conventional wisdom is that set based is best so I thought that there would be an improvement.
What does set-based have to do with...
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 2, 2014 at 6:09 am

#1718167
RE: Making Sense of Statistics

GilaMonster (6/2/2014)
In general, lower numbers are better, however those stats values are so low there's no point in tweaking.
As for subqueries vs joins, depends on where the subqueries are,...
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 2, 2014 at 5:49 am

#1718161
RE: Making Sense of Statistics

That's kind of what I meant, I'm not sure what I'm looking for! However, I don't actually have permission to run those. I'm part of the BI team...
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 2, 2014 at 5:28 am

#1718153
RE: Today's Random Word!

Passenger
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

May 28, 2014 at 8:40 am

#1717048
RE: Today's Random Word!

Geese
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

May 28, 2014 at 8:31 am

#1717042
RE: reg sql query

Ok, what did you get?
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

May 28, 2014 at 3:34 am

#1716944
RE: reg sql query

create table #OppHarSales1
(
BillNoint
,BillDatedate
,PatTypevarchar(8)
)
create table #OppHarSales2
(
ItemCodevarchar(6)
,Qtyint
,Priceint
,BillNoint
)
create table #MasterItem
(
ItemCodevarchar(6)
,Itemnamevarchar(25)
)
insert into #OppHarSales1
select 1,'2013-05-01', 'OP'union all
select 2,'2013-09-19', 'OP'union all
select 3,'2013-11-02', 'PHARMACY'union all
select 4,'2014-02-06', 'OP'union all
select 5,'2014-05-27', 'PHARMACY'
insert into #OppHarSales2
select 'GN0510',1,9,1 union all
select 'GN0510',1,9,2...
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

May 28, 2014 at 2:29 am

#1716923
RE: Laptop Dreams

GilaMonster (5/27/2014)
I need a new laptop myself, but not even considering a surface.
I have an iPad which serves the tablet role just fine. My requirements for a laptop include 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

May 27, 2014 at 2:44 am

#1716619

Viewing 15 posts - 1,036 through 1,050 (of 1,251 total)