Forum Replies Created
Viewing 15 posts - 1,606 through 1,620 (of 4,080 total)
-
RE: Join if Exists
The following code will give you the same result, but I don't think it will change your performance. The execution plan is pretty straightforward, and appears to...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Query Performance with multiple joins
Other questions:
How do you get the rows without the joins?
How big are the tables you are joining to?
Are the joined tables indexed?
What does the query execution plan look like?
Joins can...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Update records with similar values
You're quite welcome, Seth. 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
Agreed, cursors have their place
I'm really surprised to hear you say that, Lynn.
Oh wait.... I thought that said cursING. 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Please Solve This query
please solve this query waiting for immediate response
I'll echo Lynn, how have you approached this problem? Also, you will find that online forums are not geared to...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Update records with similar values
Yes. Here's one way.
Depending on the volume of rows that you have to update, there may be more performant solutions.
declare @sample table (RecID...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
ISP = Insane SQL Posse ??
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: How to find N Consecutive records in a table
So you want to ignore November 1st because it was a singleton?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: how to pass table valued parameter to anotehr sproc
Here is a modification of the example from Books Online. It is really quite simple, which leads me to ask why you are looking for another way...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
By the way, Adam. I thought you said that you didn't have time to keep up with The Thread about a dozen posts ago. Be careful,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
What do you think I have 15 acres of woods for?
Woods are good. They provide fuel for fire and draw game to your vicinity.
You...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
Apparently plagiarism detection has become quite the cottage industry. Search "plagiarism detection" and you will find a number of different offerings.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
What Jeff said. The problem is finding the documents out on the web to compare. I've heard that many schools subscribe to a service that...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
RE: Are the posted questions getting worse?
Can we quote you on that, Jeff? With proper attribution, of course. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
Viewing 15 posts - 1,606 through 1,620 (of 4,080 total)