Forum Replies Created

Viewing 15 posts - 1,471 through 1,485 (of 4,085 total)

  • RE: Question about the GO statement

    jasona.work - Wednesday, December 6, 2017 12:13 PM

    You *might* be able to do it with a cursor, but the question now would...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 6, 2017 at 12:21 pm

    #1971021

  • RE: Question about the GO statement

    Why don't you post something that's closer to your actual problem?  This particular problem can easily be solved with a set-based approach, but it sounds like your actual problem may...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 6, 2017 at 12:11 pm

    #1971015

  • RE: Next date after a return date.

    ps_vbdev - Wednesday, December 6, 2017 6:36 AM

    Yep appreciate the indexing aspect and that was next thing to tackle. I just know...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 6, 2017 at 7:43 am

    #1970928

  • RE: Query working differently on different servers

    Melanie Peterson - Tuesday, December 5, 2017 2:50 PM

    drew.allen - Tuesday, December 5, 2017 2:44 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 5, 2017 at 2:58 pm

    #1970809

  • RE: Query working differently on different servers

    My guess the value is in the prev_id field.

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 5, 2017 at 2:44 pm

    #1970807

  • RE: Did anybody have this problem

    rkordonsky 63916 - Tuesday, December 5, 2017 12:39 PM

    I have simple query:
    SELECT (select ISNULL(SUM(TOTAL_PAYMENTS),0) from Orders where ST_ID IN(SELECT ID...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 5, 2017 at 12:51 pm

    #1970782

  • RE: Today's Random Word!

    ManicStar - Tuesday, December 5, 2017 12:33 PM

    Revenant - Tuesday, December 5, 2017 11:04 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 5, 2017 at 12:41 pm

    #1970780

  • RE: Mathematics/Algorithms in SQL

    Jeff Moden - Monday, December 4, 2017 2:49 PM

    HappyGeek - Monday, December 4, 2017 11:19 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 4, 2017 at 3:23 pm

    #1970626

  • RE: Not Useless Features

    Jason A. Long - Monday, December 4, 2017 2:51 PM

    No... SQL Server is able to choose how it executes the query...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 4, 2017 at 3:22 pm

    #1970625

  • RE: Not Useless Features

    Jason A. Long - Friday, December 1, 2017 2:46 PM

    If I unpivot 5 columns, it has the same impact, in terms...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 4, 2017 at 1:51 pm

    #1970610

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Monday, December 4, 2017 11:45 AM

    ARG!!!!!!! Some former MVP's make me so angry!  (Said in the voice of the...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 4, 2017 at 11:48 am

    #1970583

  • RE: Not Useless Features

    Jason A. Long - Friday, December 1, 2017 2:46 PM

    drew.allen - Friday, December 1, 2017 2:37 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 4, 2017 at 9:04 am

    #1970544

  • RE: Not Useless Features

    Jason A. Long - Friday, December 1, 2017 2:27 PM

    drew.allen - Friday, December 1, 2017 2:06 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 1, 2017 at 2:37 pm

    #1970390

  • RE: Not Useless Features

    Jason A. Long - Friday, December 1, 2017 1:14 PM

    drew.allen - Friday, December 1, 2017 1:07 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 1, 2017 at 2:06 pm

    #1970385

  • RE: Not Useless Features

    Jason A. Long - Friday, December 1, 2017 12:41 PM

    Top of my wish list...
    #1 Inline Scalar UDFs.
    #2 GREATEST & LEAST functions.
    #3...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 1, 2017 at 1:07 pm

    #1970373

    • Viewing 15 posts - 1,471 through 1,485 (of 4,085 total)