Forum Replies Created

Viewing 15 posts - 1,486 through 1,500 (of 4,085 total)

  • RE: The Difference Between Rollup and Cube

    bpwilso - Thursday, November 30, 2017 12:38 PM

    Nice right up.  I've used these two functions to optimize a few procedures we have...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • RE: Add Column to Staging table

    You're making this much more complicated than it needs to be.  You're 1) adding a column, 2) updating the column, 3) deleting rows based on the column values, and presumably...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • RE: Current Quarter

    Jeff Moden - Monday, November 27, 2017 9:05 PM

    drew.allen - Monday, November 27, 2017 10:33 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • RE: Are the posted questions getting worse?

    ZZartin - Monday, November 27, 2017 1:34 PM

    drew.allen - Monday, November 27, 2017 1:13 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • RE: Are the posted questions getting worse?

    Thom A - Monday, November 27, 2017 7:21 AM

    It actually worries me that someone out there was under the impression that converting...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • RE: Current Quarter

    craig.jenkins - Monday, November 27, 2017 9:28 AM

    Great thank you Thom A.  Which part does  if '1st  day of the the new...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • RE: Current Quarter

    This is one of the cases where changing your point of reference greatly simplifies your calculations.  If your...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • RE: Tricky LAG() and Windowing Script

    You didn't say what results you were expecting.  John pivoted the table, but I did not.

    The issue you were having duplicating the article is that it depends on...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • RE: Better TSQL Performance

    Jeff Moden - Wednesday, November 22, 2017 8:20 AM

    PrettyMegaDBA - Wednesday, November 22, 2017 8:16 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • RE: Cumulative subtraction

    drew.allen - Tuesday, November 21, 2017 9:05 AM

    Jacob Wilkins - Friday, November 17, 2017 9:42 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • RE: Cumulative subtraction

    Jacob Wilkins - Friday, November 17, 2017 9:42 AM

    Seems to be an odd recursive thing, where for each row you compute a...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • RE: Find dependency with in different data of columns with in a table?

    Scrap the whole thing and use the right tool for the job.  You're trying to use a database to replicate a spreadsheet.  Just use a spreadsheet in the first place.

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • RE: Combine rows by applying grouping and data validation

    The main problem that you're encountering here is that your MeetingDetails table is a weird hybrid of an...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • RE: Holiday parties: Do you love them or hate them?

    Geoff.Sturdy - Monday, November 20, 2017 12:57 AM

    drew.allen - Wednesday, November 15, 2017 7:52 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • RE: Binary Date Conversions

    TomThomson - Monday, November 20, 2017 7:37 AM

    The storage format ensures that the binary max and the datetime max will be the...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

Viewing 15 posts - 1,486 through 1,500 (of 4,085 total)