Home Forums SQL Server 2005 T-SQL (SS2K5) Calculating interest query RE: Calculating interest query

  • February 26, 2010 at 3:34 pm

    #1125857

    Jeff Moden (2/26/2010)

    nathan 7372 (2/26/2010)

    Thank you for pointing out proper posting etiquette. I had not seen that article before and I apologize.

    Absolutely no problem and no need to apologize. You're new and I figured you needed a leg up to get a good answer. Looks like Chris jumped right in there as soon as you posted the data. Very well done.

    If I have time tonight after I get home from work, I'll try to show you a different way.

    Absolutely. Excellent description of the problem, easily-consumable data - what more could you ask for? 😎

    Jeff, apologies if you feel I was treading on your toes here - I figured you'd come up with a quirky update solution, so the OP will have choice. The obvious third alternative (correlated subquery/triangular join) will likely appear too - they're all yours, mate :Whistling:

    Cheers

    ChrisM

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]