Here's a wee script to get the ball rolling. No PK's / FK's yet (or even indexes), and not even fully normalised, but simple enough to use as a framework...

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...

Gianluca Sartori (10/27/2011)

---

It's an inglorious battle for...

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...

Had to post - now we're even again

Nah - you're strange, I'm a coincidence 😛

What!!! How rude!

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...

Ninja's_RGR'us (10/26/2011)

---

ChrisM@Work (10/26/2011)

---

Your script has numerous faults - I'm sure if you fix them and repost, it won't take long to solve...

Your script has numerous faults - I'm sure if you fix them and repost, it won't take long to solve this.

Celko's less personally offensive. This guy would benefit from a warning shot...

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...

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...

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...

I've had two HTC phones, the XDA and the XDA IIs. Both performed really well and...