Forum Replies Created

Viewing 15 posts - 901 through 915 (of 4,085 total)

  • RE: Fastest Way to Update Rows in a Large Table in SQL Server

    I think the following is going to be faster and simpler.  It only reads the table once each loop instead of once to insert into the temp table and once...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 17, 2018 at 2:20 pm

    #2006050

  • RE: View - failed because it contains a derived or constant field.

    sgmunson - Monday, September 17, 2018 11:17 AM

    ikrami2000 - Sunday, September 16, 2018 6:22 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 17, 2018 at 12:01 pm

    #2006009

  • RE: Multiple Join Behaviour

    RonKyle - Friday, September 14, 2018 1:04 PM

    I mean that it will usually be impossible to tell whether Table C is...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 17, 2018 at 11:50 am

    #2006005

  • RE: Dynamic "FOR XML PATH" in SQL 2014

    BOR15K - Monday, September 17, 2018 9:56 AM

    drew.allen - Monday, September 17, 2018 9:52 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 17, 2018 at 10:12 am

    #2005987

  • RE: Dynamic "FOR XML PATH" in SQL 2014

    You've been around long enough to know that you should provide sample data and expected results.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 17, 2018 at 9:52 am

    #2005978

  • RE: View - failed because it contains a derived or constant field.

    ikrami2000 - Sunday, September 16, 2018 6:22 AM

    I have this View:

    Create View xyz As
    Select Value,
    MAX(Case When Other = 'Color' Then Description...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 17, 2018 at 9:39 am

    #2005977

  • RE: Line and Columns combination

    Thom A - Monday, September 17, 2018 9:22 AM

    drew.allen - Monday, September 17, 2018 8:49 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 17, 2018 at 9:30 am

    #2005972

  • RE: Line and Columns combination

    I don't consider this a CROSS JOIN.  It's an INNER JOIN on GPID and Name.  A CROSS JOIN would produce 36 rows, whereas this only has 18.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 17, 2018 at 8:49 am

    #2005959

  • RE: Identifying NEW/RETAIN/LOST unique_id

    alexander.lummer - Friday, September 14, 2018 1:52 PM

    How would you prefer I provide you with a sample data?

    Please see my very first...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 14, 2018 at 3:14 pm

    #2005854

  • RE: Identifying NEW/RETAIN/LOST unique_id

    alexander.lummer - Friday, September 14, 2018 12:11 PM

    Can i attach an excel file? will make it easier

    Yes, you can attach an Excel...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 14, 2018 at 1:36 pm

    #2005848

  • RE: Multiple Join Behaviour

    RonKyle - Friday, September 14, 2018 12:50 PM

    That's not true at all. Here is an easy demonstration of that fact.

    You...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 14, 2018 at 1:05 pm

    #2005842

  • RE: Multiple Join Behaviour

    NikosV - Friday, September 14, 2018 12:35 PM

    drew.allen - Friday, September 14, 2018 12:22 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 14, 2018 at 12:51 pm

    #2005838

  • RE: Multiple Join Behaviour

    RonKyle - Friday, September 14, 2018 12:14 PM

    Table C is joining to Table A's initial state.  But the final result will be affected...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 14, 2018 at 12:40 pm

    #2005833

  • RE: Multiple Join Behaviour

    It's complicated by the fact that there are actually two different (but related) behaviors: logical and physical processing.  Think of it as the logical is how humans think about it...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 14, 2018 at 12:22 pm

    #2005828

  • RE: How do I write a record for each day in a date range???

    andycadley - Friday, September 14, 2018 9:03 AM

    +1 billion on FOMONTH. How on earth was that not so obviously needed for exactly...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 14, 2018 at 10:03 am

    #2005801

Viewing 15 posts - 901 through 915 (of 4,085 total)