Forum Replies Created

Viewing 15 posts - 1 through 15 (of 620 total)

  • RE: x64 SQL 2012 Express on x64 machine

    In case anyone is interested, I had no problem using the 32 bit installation package on x64 machine. It had no problem finding the correct DSN from the 32...

  • RE: Create table from rows of a different table

    rolinoberto (3/6/2015)


    suppose I have an application, which is used to fill and use the information stored in a database, suppose (after a couple of months/later on) I add a new...

  • RE: Mortgage amortization table

    dwain.c (3/4/2015)


    Bwahahaha! How in the world did you dig up such an ancient thread?!

    And while ancient, I do still recall Paul White's unbelievable contribution to it. I think...

  • RE: Mortgage amortization table

    Thank you so much Solomon. I never cease to be impressed by the generosity shown by folks here, and their willingness to go above and beyond on someone else's...

  • RE: Mortgage amortization table

    henryalugo (3/3/2015)


    Thank everyone for all the relative insight!

    No problem Henry, I'm glad to see you got it working as needed. I am taking the time to incorporate all of...

  • RE: Mortgage amortization table

    dwain.c (3/1/2015)


    Thanks for saying it was an "excellent article" even with such discrepancies. 😀 Glad you felt like being generous today.

    Excellent article indeed Dwain. Especially from a guy who...

  • RE: Mortgage amortization table

    Wow, Solomon, thank you for all the info. I don't remember exactly how I got the original formula, but I think I just messed around with it in Excel...

  • RE: Last orders for each customerid

    This one would fail (or show 2 rows for one customer) if 2 rows had the same date

    If the system is designed so there are not 2 rows with the...

  • RE: Mortgage amortization table

    ScottPletcher (2/26/2015)


    Change to money rather than more decimal places. I believe the law now restricts to 4 decimal places when calculating most interest accumulation.

    Scott, I tried money, float, decimal...

  • RE: Mortgage amortization table

    Solomon Rutzky (2/25/2015)It returns instantly. Of course, I have never found a reliable calculation to compare against. I have seen that it is generally correct, but testing against http://www.mortgagecalculator.org/ just...

  • RE: Help in query

    Maybe this is an over-simplification, but you could test it versus the other methods provided.

    SELECT

    a.[Pax ID], a.[Flight Date], a.[Flight Number],

    ISNULL(b.[Last Mod Date], a.[Last Mod Date]) AS [Last Mod...

  • RE: Mortgage amortization table

    henryalugo (2/24/2015)


    Yeah I realized from all the postings that this subject has not been in the fore front, but as an avid T-SQL user I am tasked to create an...

  • RE: Mortgage amortization table

    Wow, Henry, it's been years since I thought about this one. How ironic that I started this thread in rebuff to a friend's assertion that SAS is better than...

  • RE: import data from SQL to SPSS?

    Beth, I don't remember much about SPSS from school, but I do use SAS every day, and it is 'normal' for stats procedures to run on a de-normalized dataset, where...

  • RE: Unable to reply to some forums<!-- 864 -->

    And what I just realized, and this proves it, is that it only happens to me if I am attempting to submit the first reply to a post. If...

Viewing 15 posts - 1 through 15 (of 620 total)