Forum Replies Created

Viewing 15 posts - 1,396 through 1,410 (of 4,085 total)

  • RE: Not getting the right result either due to grouping or join

    Let's start by providing some sample data and expected results as outlined in the first link in my signature.  This will help answer some basic questions.

    Also, you say...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 22, 2017 at 7:28 am

    #1973261

  • RE: ? on getting all data before a blank line ?

    Use PATINDEX to search for two consecutive line terminators.  So the next question is whether your data uses Windows (CrLf), Mac(Cr), or Unix(Lf) line terminators.

    Of course, this assume...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 21, 2017 at 2:01 pm

    #1973178

  • RE: usage of DISTINCT OPERATOR

    vsamantha35 - Thursday, December 21, 2017 1:37 PM

    Hi All,

    Is there a better way to rewrite below code without using DISTINCT operator. Other...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 21, 2017 at 1:49 pm

    #1973174

  • RE: Are the posted questions getting worse?

    Hugo Kornelis - Thursday, December 21, 2017 1:38 PM

    drew.allen - Thursday, December 21, 2017 12:53 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 21, 2017 at 1:44 pm

    #1973171

  • RE: Suggestions on a query plan

    vsamantha35 - Thursday, December 21, 2017 1:06 PM

    drew.allen - Thursday, December 21, 2017 1:04 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 21, 2017 at 1:26 pm

    #1973165

    • Viewing 15 posts - 1,396 through 1,410 (of 4,085 total)