Forum Replies Created

Viewing 15 posts - 1,006 through 1,020 (of 4,086 total)

  • RE: Hierarchical AND/OR Path Sets

    I think this would be a lot easier with several specific examples rather general hand-waving.  That being said, I think that if you stop thinking about AND/OR and instead think...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    August 21, 2018 at 3:19 pm

    #2002767

  • RE: Joining tables

    venuvedham16 - Tuesday, August 21, 2018 12:09 PM

    drew.allen - Tuesday, August 21, 2018 11:51 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    August 21, 2018 at 12:56 pm

    #2002739

  • RE: Joining tables

    You're going to learn a lot more if you do your own homework.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    August 21, 2018 at 11:51 am

    #2002728

  • RE: Non Clustered Index on Phone column

    Jeff Moden - Tuesday, August 21, 2018 10:43 AM

    Eirikur Eiriksson - Tuesday, August 21, 2018 10:13 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    August 21, 2018 at 11:27 am

    #2002725

  • RE: Procedure Result taking more time

    jkramprakash - Tuesday, August 21, 2018 10:56 AM

    I tried to use this below command in end of my first query before Union...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    August 21, 2018 at 11:23 am

    #2002724

  • RE: Best way to join onto same table to extract different data

    Please don't start multiple threads for essentially the same question.  You were already told in the other thread how to rewrite this.  If you are still having issues with it,...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    August 21, 2018 at 9:41 am

    #2002701

  • RE: Prevent duplicates in a table

    Senchi - Monday, August 20, 2018 3:18 PM

    Though I appreciate your opinions can somebody actually tell me on how to accomplish this...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    August 20, 2018 at 3:28 pm

    #2002586

  • RE: Import MIllion rows into Excel

    sathwik.em91 - Monday, August 20, 2018 2:53 PM

    Phil Parkin - Monday, August 20, 2018 2:46 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    August 20, 2018 at 3:00 pm

    #2002580

  • RE: Prevent duplicates in a table

    Jeff Moden - Monday, August 20, 2018 2:13 PM

    RonKyle - Monday, August 20, 2018 9:37 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    August 20, 2018 at 2:32 pm

    #2002575

  • RE: ADDING FIELDS WITH A SELECT STATEMENT

    sahoong - Monday, August 20, 2018 12:43 PM

    I need help with the subtotal rows. I want to add the GLAMount from previous...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    August 20, 2018 at 1:14 pm

    #2002554

  • RE: ADDING FIELDS WITH A SELECT STATEMENT

    sahoong - Monday, August 20, 2018 12:03 PM

    its in spreadsheet and I am developing an SSRS Report for it.

    If this is for...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    August 20, 2018 at 12:10 pm

    #2002538

  • RE: Rollup with Group by

    ROLLUP will always produce a grand total.  If you don't want a grand total, you should be using GROUPING SETS instead, because it allows you to specify exactly which totals...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    August 20, 2018 at 8:00 am

    #2002484

  • RE: RegEx with flexible parts

    adiedler - Monday, August 20, 2018 2:25 AM

    Hello, I search the forum for similar cases but does not found a matching entry. 
    We...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    August 20, 2018 at 7:39 am

    #2002480

  • RE: Store multiple strings efficient in sql

    NikosV - Monday, August 20, 2018 2:30 AM

    I have 157 values (varchar) in a table but I am only interested in say...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    August 20, 2018 at 7:28 am

    #2002474

  • RE: Today's Random Word!

    below86 - Friday, August 17, 2018 2:25 PM

    Camp

    RuPaul

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    August 17, 2018 at 2:32 pm

    #2002322

Viewing 15 posts - 1,006 through 1,020 (of 4,086 total)