Forum Replies Created

Viewing 15 posts - 1,321 through 1,335 (of 4,086 total)

  • RE: Help me in update - complex

    You're overcomplicating your formula.  There is no reason to cast to float. Just use integer division.

    UPDATE t1
    SET set_no = t2.set_no
    FROM #sample t1
    INNER JOIN...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 24, 2018 at 8:56 am

    #1977120

  • RE: Question Regarding Date logic

    ScottPletcher - Tuesday, January 23, 2018 2:57 PM

    drew.allen - Tuesday, January 23, 2018 2:33 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 23, 2018 at 3:13 pm

    #1977008

  • RE: Question Regarding Date logic

    ScottPletcher - Tuesday, January 23, 2018 2:24 PM

    Does YYYY-MM-00 raise 1NF / atomicity issues?  Does the column represent an atomic date or...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 23, 2018 at 2:33 pm

    #1977004

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

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

    Had to fiddle with your code, Drew. It didn't take into account multiple Address...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 23, 2018 at 1:47 pm

    #1976995

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

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

    How about this, Brandie. You could use DATEDIFF() to find which of two address rows is...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 23, 2018 at 8:45 am

    #1976922

  • RE: Question Regarding Date logic

    below86 - Tuesday, January 23, 2018 7:44 AM

    Thanks for the info Jeff, I'll take a look at it.  As I've stated...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 23, 2018 at 8:23 am

    #1976915

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

    There are two approaches.  Which one performs better depends on how dense the address table is with respect to the invoice table, but since the invoice table also has duplicates,...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 23, 2018 at 7:39 am

    #1976900

  • RE: Question Regarding Date logic

    ScottPletcher - Monday, January 22, 2018 1:50 PM

    Using 0 for a date is common enough that it's not "cutesy".  But I...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 22, 2018 at 2:27 pm

    #1976821

  • RE: Question Regarding Date logic

    ScottPletcher - Monday, January 22, 2018 1:50 PM

    At any rate, say if I want to get the 15th of the month, what...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 22, 2018 at 2:10 pm

    #1976815

  • RE: Question Regarding Date logic

    ScottPletcher - Monday, January 22, 2018 12:14 PM

    drew.allen - Monday, January 22, 2018 11:35 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 22, 2018 at 1:29 pm

    #1976805

  • RE: Question Regarding Date logic

    below86 - Monday, January 22, 2018 1:16 PM

    ScottPletcher - Monday, January 22, 2018 1:05 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 22, 2018 at 1:25 pm

    #1976802

  • RE: Question Regarding Date logic

    ScottPletcher - Monday, January 22, 2018 11:05 AM

    below86 - Monday, January 22, 2018 10:58 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 22, 2018 at 11:35 am

    #1976783

  • RE: Question Regarding Date logic

    below86 - Monday, January 22, 2018 9:48 AM

    This may be 'the long way around the barn', but it works.  You could set...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 22, 2018 at 9:54 am

    #1976758

  • RE: Coding for Date Range for Specific Weekday- Time (Week To Date) Query

    rsiem - Friday, January 19, 2018 3:49 PM

    Drew:

    I think I have most of the problem solved especially the end period - I...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 22, 2018 at 7:58 am

    #1976727

  • RE: Compare previous and next rows to derive output

    GroverVivek - Saturday, January 20, 2018 1:15 AM

    drew.allen - Friday, January 19, 2018 8:48 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 22, 2018 at 7:41 am

    #1976723

Viewing 15 posts - 1,321 through 1,335 (of 4,086 total)