Carl Federl (6/28/2008)

---

This appears to be a variation on First-In First-Out allocation such as for allocating Payments to Invoices or for "best fit"

Someone posted a SQL solution this month but...

That's kinda what I thought you were going to say.

What I was suggesting is that the distance from Point A to Point B is exactly the same as...

So, how did you solve the problem of both being optional AND unique?

If you're going to spend that much time on it... write it as an article and submit it, instead. 😉

As a side bar... you said something very important... you said...

Already did... but I'll say it again here... write a batch file to move the files......

That was a great idea you had, Barry.

No doubt about that... 🙂

dfalso (6/27/2008)

---

In order to be truly safe, dynamic sql is needed, unless we could write a CTE with an input variable that governs the amount of recursion (again, on...

Matt Miller (6/27/2008)

---

I personally roll with a tally table with a 1M limit, but that's a personal choice.

Otherwise - it's very easy to come up with a numbers table of...

pduplessis (6/28/2008)

---

I am with Jim on this one, it...

If you change Carl's code to 2000 per customer, you see where Triangular Joins really start to fall apart... time goes up by a factor of 4 for the Triangular...

Thanks, but Sergiy was first to set you on the right track.

rbarryyoung (6/28/2008)

---

Actually, no. This is what you are trying...

am (6/28/2008)

---

Thanks for your response

Alloc Amt is calculated based on Priority and Alloc Percent from EMPPERCENTTABLE. For EMPID - 1001 and 1002 where priority is 1 so whatever gets paid...

SELECT ep.Record,ep.EmpID,r.ReceiptNum,r.Paid,ep.Beg_Balance

FROM EmpPercentTable ep

CROSS JOIN ReceiptsTable r

ORDER BY r.ReceiptNum,ep.EmpID

I'm a bit tired and today's coffee has finally worn off... what formula are...