ChrisM@Work

Forum Replies Created

Viewing 15 posts - 6,511 through 6,525 (of 10,143 total)

RE: self Join [Help Required]

arslantalib (10/27/2011)
thanks for your response, problem is still not solved with my actual data,
can you please give your email, so i can send you my actual data...
VSP (10/12/2011)
I may have...
^{“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

October 27, 2011 at 6:14 am

#1400090
RE: Are the posted questions getting worse?

Gianluca Sartori (10/27/2011)
ChrisM@Work (10/27/2011)
Gianluca Sartori (10/27/2011)
ChrisM@Work (10/27/2011)
Gianluca Sartori (10/27/2011)
Strange coincidence!
...
Nah - you're strange, I'm a coincidence 😛
:hehe: Quite right.
Had to post - now we're even again
It's an inglorious battle for...
^{“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

October 27, 2011 at 4:49 am

#1400059
RE: Retrieving status from history

This is probably more efficient:
SELECT
O.OrderID,
l.StatusID,
l.StatusDate
FROM Orders O
INNER JOIN (
SELECT *, rn = ROW_NUMBER() OVER(PARTITION BY OrderID ORDER BY StatusDate)
FROM OrderStatusLog
) l ON l.OrderID = o.OrderID AND l.rn...
^{“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

October 27, 2011 at 4:49 am

#1400058
RE: Are the posted questions getting worse?

Gianluca Sartori (10/27/2011)
ChrisM@Work (10/27/2011)
Gianluca Sartori (10/27/2011)
Strange coincidence!
...
Nah - you're strange, I'm a coincidence 😛
:hehe: Quite right.
Had to post - now we're even again
^{“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

October 27, 2011 at 4:10 am

#1400046
RE: Are the posted questions getting worse?

Gianluca Sartori (10/27/2011)
Strange coincidence!
...
Nah - you're strange, I'm a coincidence 😛
^{“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

October 27, 2011 at 3:55 am

#1400041
RE: Are the posted questions getting worse?

Jim Murphy (10/26/2011)
... Aaahhh. It's sweet. Now I can grant permissions to both my wife (at home), and my receptionist (at work)...Jim
What!!! How rude!
^{“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

October 27, 2011 at 2:14 am

#1400017
RE: Summation of amount in T-Sql

Here's the OUTER APPLY version Remi's talking about. It's cleaner, easier to read, and likely to be more performant:
SELECT m.LastName,
p.PledgeTotalPerIndividual,
ps.LTVTotalPerIndividual,
ps.RoRTotalPerIndividual,
t.OfferingTotalPerIndividual,
t.TitheTotalPerIndividual,
t.SeedOfferingPerIndividual
FROM dbo.Members AS m
OUTER APPLY (SELECT...
^{“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

October 26, 2011 at 7:42 am

#1399605
RE: Summation of amount in T-Sql

Ninja's_RGR'us (10/26/2011)
ChrisM@Work (10/26/2011)
SaintGr8 (10/26/2011)
Hello!
Please run the queries below to get along....
Your script has numerous faults - I'm sure if you fix them and repost, it won't take long to solve...
^{“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

October 26, 2011 at 6:43 am

#1399543
RE: Summation of amount in T-Sql

SaintGr8 (10/26/2011)
Hello!
Please run the queries below to get along....
Your script has numerous faults - I'm sure if you fix them and repost, it won't take long to solve 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

October 26, 2011 at 6:34 am

#1399535
RE: Are the posted questions getting worse?

L' Eomot Inversé (10/26/2011)
Do we have a would-be Celko here? A somewhat style-less and inept one, perhaps, but...
Celko's less personally offensive. This guy would benefit from a warning shot...
^{“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

October 26, 2011 at 6:28 am

#1399525
RE: If or case statement to determine a join

clarmatt73 (10/26/2011)
This is the from clause for the query:
FROM [Transaction] Payments
INNER JOIN Debt ON Debt.DebtCode = Payments.TransactionDebtCode
IF @JointDebtor = 'Yes'
(INNER JOIN DebtDebtor ON DebtDebtor.DebtCode=Debt.DebtCode AND DebtDebtor.DebtorLinkId=ISNULL(TransactionDebtorLinkId,(SELECT MIN(DebtDebtorID) FROM DebtDebtor AS...
^{“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

October 26, 2011 at 5:59 am

#1399513
RE: If or case statement to determine a join

clarmatt73 (10/26/2011)
Just re-read my post, the example did not quite show how the joins are written. Please see below:
(Case When @parameter = 'Yes' THEN
INNER JOIN Table2 ON Table2.DebtCode=Table1.DebtCode AND Table2.DebtorLinkId=ISNULL(TransactionDebtorLinkId,(SELECT...
^{“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

October 26, 2011 at 5:16 am

#1399496
RE: If or case statement to determine a join

clarmatt73 (10/26/2011)
Hi All,
I have been asked to alter one of our reports so that the end users can select whether to include certain data. The data can only be extracted...
^{“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

October 26, 2011 at 4:38 am

#1399489
RE: Are the posted questions getting worse?

Brandie Tarvin (10/25/2011)
...
So I went with the newly unveiled (as of Sunday), HTC Evo Design.
I've had two HTC phones, the XDA and the XDA IIs. Both performed really well and...
^{“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

October 26, 2011 at 4:01 am

#1399473
RE: Introduction to Indexes: Part 2 – The clustered index

GilaMonster (10/24/2011)
ChrisM@Work (10/24/2011)
So if a table has 4.5 million rows and the Clustered Index Scan operator properties sheet displays "Actual number of rows 720939" for a query against that table,...
^{“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

October 26, 2011 at 2:18 am

#1399436

Viewing 15 posts - 6,511 through 6,525 (of 10,143 total)