I found this example very useful.

I do have a question regarding the efficiency of using recursion. Even though is get rids of explicit loops, does it result in...

The sum of quantities encompasses all the UnitNo's of a customer in one single Total Qty for each customer, not separate sums for each individual UnitNo.

I would expect the...

The CustomerTotal is the "to-date" value, i.e. the current sum of all quantities in all units up till the current transaction.

If an existing customer acquires a second UnitNo,...

Finally out that meeting.

Works like a cham.

Thanks a million.

It's been quite a while since I used SQL Server Central - there used to be...

Thank you for your prompt reply.

I just got harpooned in a staff meeting, so I will try it later tonight.

Regards

Isn't using undocumented procedures simply asking for trouble ?

I definitely have to bone up on the WITH CHECK option.

Thank you for bringing this up Steve.

Learn something new every day.

tripleAxe (9/15/2016)

---

Some basic testing on my VM using the original table as posted but with 12 million rows of data has the UNION ALL query taking 6 seconds with the...

Again, another example of multiple senior contributors moving the goal posts farther away to better explore the subject, even...

Thank you for taking the time of finding the links.

Will definitely look them up.

Regards

J Livingston SQL (9/14/2016)

---

"Still not in the mindset of a...

Clear explanation, thank you all.

Still not in the mindset of a million rows ... My DB's are considerably more modest.

Yes, this was my question from the...

Got surprised by that one. Not particularly intuitive.

Not that I would have committed it to production code, I would have found out by testing it.

By the way, this one...

A bit of ancient history.

The problem with the GOTO was magnified by the style...