Forum Replies Created

Viewing 15 posts - 706 through 720 (of 9,715 total)

  • RE: Grouping dates and IDs together

    Drew, thank you so very much. I'd never heard of LAG() or the ROWS UNBOUNDED PRECEDING stuff until now. I love this job because I learn new things every day.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    February 10, 2018 at 1:29 pm

    #1979356

  • RE: Grouping dates and IDs together

    drew.allen - Friday, February 9, 2018 3:29 PM

    If you look at POID 1099563, it delivers to sites 2607 and 2608, but POID 1189651...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    February 10, 2018 at 6:52 am

    #1979344

  • RE: Tying MAX() value to <= value from another table

    drew.allen - Tuesday, January 23, 2018 1:47 PM

    Brandie Tarvin - Tuesday, January 23, 2018 1:20 PM

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    January 23, 2018 at 3:40 pm

    #1977012

  • RE: Tying MAX() value to <= value from another table

    Had to fiddle with your code, Drew. It didn't take into account multiple Address codes on a single invoice. Then again, neither did my sample data because I didn't see...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    January 23, 2018 at 1:20 pm

    #1976987

  • RE: Tying MAX() value to <= value from another table

    Almost 3 hours later and the CTE is still trying to run. I'm going to yank it out, run the code for PayDate = LastAccountDate, then do an update for...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    January 23, 2018 at 11:32 am

    #1976964

  • RE: Tying MAX() value to <= value from another table

    drew.allen - Tuesday, January 23, 2018 8:45 AM

    ChrisM@Work - Tuesday, January 23, 2018 7:50 AM

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    January 23, 2018 at 8:53 am

    #1976925

  • RE: Tying MAX() value to <= value from another table

    It occurs to me that no matter what way I go, all of these solutions will need to be put in a CTE since I'm joining to multiple tables (not...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    January 23, 2018 at 8:40 am

    #1976921

  • RE: Tying MAX() value to <= value from another table

    Thanks. I'll check those out... I didn't even think about CROSS APPLY. I keep forgetting about that.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    January 23, 2018 at 7:44 am

    #1976902

  • RE: Are the posted questions getting worse?

    And yes, I just womansplained how to change a car battery. Feels good to be the one doing the "splaining" for once. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    January 5, 2018 at 5:27 am

    #1974644

  • RE: Are the posted questions getting worse?

    jasona.work - Friday, January 5, 2018 5:22 AM

    ARGH!
    What a *lovely* start (or, perhaps more appropriately, NON-start) to the day...
    Go out to the...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    January 5, 2018 at 5:26 am

    #1974643

  • RE: Are the posted questions getting worse?

    And here's AMD's response to the whole thing: https://www.amd.com/en/corporate/speculative-execution

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    January 5, 2018 at 3:54 am

    #1974634

  • RE: Are the posted questions getting worse?

    Can I just point out how much I love this site because of things like the main article in today's newsletter...

    And here's a link of interest if you haven't...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    January 5, 2018 at 3:40 am

    #1974633

  • RE: Are the posted questions getting worse?

    I remember the one time it snowed in South Carolina when I lived there. Only about 2 inches. Nobody, and I mean NOBODY, on the road as I drove to...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    January 3, 2018 at 12:42 pm

    #1974325

  • RE: Are the posted questions getting worse?

    Jeff Moden - Wednesday, January 3, 2018 10:28 AM

    Brandie Tarvin - Wednesday, January 3, 2018 9:34 AM

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    January 3, 2018 at 12:27 pm

    #1974319

  • RE: Are the posted questions getting worse?

    We don't turn off our AC until about mid-December and then it's back on by the end of February. Our attic traps a lot of heat.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    January 3, 2018 at 9:34 am

    #1974272

Viewing 15 posts - 706 through 720 (of 9,715 total)