Forum Replies Created

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

  • RE: Weird variables / expressions issue

    The worst part about it is the people who were developing this code kept insisting on turning SQL tables into flat files and doing stupid stuff like that, no matter...

    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 23, 2018 at 10:55 am

    #1980971

  • RE: Grouping dates and IDs together

    Thanks, Drew. I was working on that, but changing different items in the CASE. I'll take a look at that and see how it works.

    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 13, 2018 at 5:12 am

    #1979576

  • RE: Grouping dates and IDs together

    drew.allen - Monday, February 12, 2018 12:12 PM

    Brandie Tarvin - Monday, February 12, 2018 11:46 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.

    February 12, 2018 at 12:27 pm

    #1979502

  • RE: Grouping dates and IDs together

    Lynn Pettis - Monday, February 12, 2018 11:50 AM

    Brandie Tarvin - Monday, February 12, 2018 11:46 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.

    February 12, 2018 at 12:16 pm

    #1979495

  • RE: Grouping dates and IDs together

    BAH. I thought I was through with this, but I just found an outlier.

    When testing with the this data:

    INSERT INTO #MyTemp (Office, POID, DeliverySite,...

    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 12, 2018 at 11:46 am

    #1979482

  • 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

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