Forum Replies Created

Viewing 15 posts - 3,571 through 3,585 (of 7,609 total)

  • RE: Question Regarding Date logic

    But if only the start date is in the row, how do you handle "changes in interval"?  And especially a variable interval, say, where some rows apply for 2 weeks...

  • RE: With Schemabinding

    RonKyle - Thursday, January 25, 2018 9:15 AM

    You seem fixed to the idea that "every view must be schema bound." That's...

  • RE: With Schemabinding

    You seem fixed to the idea that "every view must be schema bound." That's just not true, and probably not even optimal.

  • RE: Question Regarding Date logic

    Sergiy - Thursday, January 25, 2018 8:28 AM

    Below86The only thing I can say is that low scale of the project is no...

  • RE: With Schemabinding

    I simply offered an alternative: rather than searching for errors yourself, let SQL find them for using sp_refreshview. Probably on your qa/test system,  as the views are likely identical or...

  • RE: With Schemabinding

    pdanes - Thursday, January 25, 2018 7:17 AM

    ScottPletcher - Thursday, January 25, 2018 6:56 AM

  • RE: Question Regarding Date logic

    Sergiy - Wednesday, January 24, 2018 8:28 PM

    Say we have your table with only beginning dates. Now I want to join to...

  • RE: With Schemabinding

    pdanes - Wednesday, January 24, 2018 5:15 PM

    ScottPletcher - Wednesday, January 24, 2018 12:46 PM

  • RE: Question Regarding Date logic

    Sergiy - Wednesday, January 24, 2018 3:11 PM

    Sometimes when joining, it's easier if the ending value is in the row itself. It's...

  • RE: With Schemabinding

    pdanes - Wednesday, January 24, 2018 12:03 PM

    ScottPletcher - Wednesday, January 24, 2018 7:10 AM

  • RE: Question Regarding Date logic

    Lynn Pettis - Wednesday, January 24, 2018 9:33 AM

    ScottPletcher - Wednesday, January 24, 2018 9:26 AM

    January 24, 2018 at 9:37 am

    #1977139

  • RE: Question Regarding Date logic

    Jeff Moden - Wednesday, January 24, 2018 9:21 AM

    ScottPletcher - Wednesday, January 24, 2018 9:01 AM

    January 24, 2018 at 9:28 am

    #1977134

  • RE: Question Regarding Date logic

    Lynn Pettis - Wednesday, January 24, 2018 9:20 AM

    ScottPletcher - Wednesday, January 24, 2018 9:01 AM

    January 24, 2018 at 9:26 am

    #1977132

  • RE: Question Regarding Date logic

    Lynn Pettis - Tuesday, January 23, 2018 4:10 PM

    ScottPletcher - Tuesday, January 23, 2018 4:04 PM

    January 24, 2018 at 9:01 am

    #1977123

  • RE: Question Regarding Date logic

    Jeff Moden - Wednesday, January 24, 2018 8:37 AM

    Sergiy - Wednesday, January 24, 2018 3:00 AM

    January 24, 2018 at 8:50 am

    #1977119

Viewing 15 posts - 3,571 through 3,585 (of 7,609 total)