ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,791 through 8,805 (of 10,143 total)

RE: What is wrong with my update statement??

Paula (2/16/2009)
The result for this is now zero, having ran the update. I know it has not done a blanket update on the whole table as there are many...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 16, 2009 at 9:37 am

#944670
RE: What is wrong with my update statement??

You might not be making any mistakes at all, depending on what you reply to Ninja. The UPDATE looks a lot simpler written as a straightforward UPDATE...FROM though, particularly if...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 16, 2009 at 9:25 am

#944657
RE: Query Tune

Experiment, Mike. Since you're using IN () in the second query, you don't need DISTINCT in the first unless it's to dramatically reduce the rowcount because you're feeding into a...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 13, 2009 at 2:17 pm

#943931
RE: Are the posted questions getting worse?

Lynn Pettis (2/13/2009)
... and one of them I got down here where I work now. If I could get the other one, in a heartbeat.
Heh yeah I know what...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 13, 2009 at 9:36 am

#943740
RE: Are the posted questions getting worse?

Lynn Pettis (2/13/2009)
Not saying this is true of all PhD's, but many of the ones I have met seemed to have lost one very important thing, common sense. Is...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 13, 2009 at 9:16 am

#943714
RE: Are the posted questions getting worse?

Roy Ernest (2/13/2009)
It will look bloody good on the resume....:hehe:
Funny you should say that...it's been said that you should study for a PhD for yourself, not for anyone else -...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 13, 2009 at 9:04 am

#943707
RE: Query window

Mike Levan (2/13/2009)
what is the work around for this so the it never happens again.
B****slap your network engineer, tell them not to let it happen again or there will be...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 13, 2009 at 8:44 am

#943683
RE: Are the posted questions getting worse?

GilaMonster (2/13/2009)
Chris Morris (2/13/2009)
But what if he (or she) is only 18 and the only person for miles around who's got hold of a lappy and a copy of SQL...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 13, 2009 at 8:28 am

#943662
RE: Query window

Mike Levan (2/13/2009)
is there any clue why i get disconnectyed all of a sudden. and i get this error mesg
"A transport-level error has occurred when sending the request to the...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 13, 2009 at 8:21 am

#943652
RE: Are the posted questions getting worse?

Michael Earl (2/13/2009)
Roy Ernest (2/13/2009)
Allright... Thanks for the explanation..
Did you see this question?? :ermm:
Don't you regularly export relational database systems to an Excel file?
All the time. Why restrict yourself to...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 13, 2009 at 6:55 am

#943532
RE: Query Tune

Mike Levan (2/13/2009)
Chris
I dont see any diffrence in your query when compared to mine. Its just the same, then how would that improve performance?
There's no difference at all, Mike, just...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 13, 2009 at 6:49 am

#943521
RE: Are the posted questions getting worse?

Roy Ernest (2/13/2009)
Chris Morris (2/13/2009)
Jeff Moden (2/12/2009)
Heh... nope... that's my ol' "buddy"... and those are typical questions from him.
This poster's been active for a couple of years...quite a few of...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 13, 2009 at 6:38 am

#943505
RE: Query Tune

Hi Mike
Can you put all the table aliases into the first query please?
select distinct a.RevID
into #Rev
from vwBud as a inner join dbo.datesJi as b
on a.RevID=b.RevID
where (JoinDt between '12/4/2001'...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 13, 2009 at 6:05 am

#943483
RE: Are the posted questions getting worse?

Jeff Moden (2/12/2009)
Heh... nope... that's my ol' "buddy"... and those are typical questions from him.
This poster's been active for a couple of years...quite a few of his posts might make...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 13, 2009 at 1:05 am

#943380
RE: A sproc

feodon (2/12/2009)
the error now is :
Msg 4104, Level 16, State 1, Procedure SearchFlightByCities, Line 41
The multi-part identifier "fff.airline_id" could not be bound.
But I'm baffled about it ,
could anyone alter this...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

February 12, 2009 at 10:17 am

#943026

Viewing 15 posts - 8,791 through 8,805 (of 10,143 total)