Forum Replies Created

Viewing 15 posts - 1,411 through 1,425 (of 4,085 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Thursday, December 21, 2017 12:55 PM

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

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 21, 2017 at 1:08 pm

    #1973160

  • RE: Suggestions on a query plan

    vsamantha35 - Thursday, December 21, 2017 12:48 PM

    Thanks Lynn. One more thing, I want to ask is that, how can we make...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 21, 2017 at 1:04 pm

    #1973157

  • RE: Are the posted questions getting worse?

    How much query tuning can you really expect from a simple select statement that only returns seven rows with no joins, a single SARGable where condition, and a sort?

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 21, 2017 at 12:53 pm

    #1973154

  • RE: Coffee sales for just 7am to 8am but for the entire year?

    qilianzangao - Thursday, December 21, 2017 10:18 AM

    Assuming you are in oracle, I will do it like this:

    SELECT *
    FROM TicketItem
    WHERE CAST(SUBSTR(TO_CHAR(dt_when,...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 21, 2017 at 11:41 am

    #1973141

  • RE: Find a sub string in a column based on values in a reference table

    fparker 20089 - Thursday, December 21, 2017 10:17 AM

    Thanks a bunch. I think I am good, this gives me a better look...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 21, 2017 at 10:20 am

    #1973128

  • RE: Find a sub string in a column based on values in a reference table

    fparker 20089 - Thursday, December 21, 2017 9:52 AM

    That does work except I will get 2 results for that one. I have...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 21, 2017 at 10:02 am

    #1973121

  • RE: Find a sub string in a column based on values in a reference table

    fparker 20089 - Thursday, December 21, 2017 9:31 AM

    This is not working with the % but it does work without it. 

    SELECT   ,[Name] ...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 21, 2017 at 9:35 am

    #1973114

  • RE: Today's Random Word!

    TomThomson - Wednesday, December 20, 2017 2:14 PM

    jasona.work - Wednesday, December 20, 2017 2:06 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 20, 2017 at 2:36 pm

    #1973005

  • RE: Help with aggregate function

    ger_serrano - Wednesday, December 20, 2017 10:28 AM

    I will check that part Jeff. I was checking all the possible scenarios and I...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 20, 2017 at 2:31 pm

    #1973003

  • RE: Solving FIFO Queues Using Windowed Functions

    louisjeorge75 - Wednesday, December 20, 2017 5:02 AM

    hi drew ,

    that is wonderful work , i need a help to write this in...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 20, 2017 at 10:16 am

    #1972949

  • RE: Distinct of two columns?

    tacy.highland - Wednesday, December 20, 2017 9:30 AM

    My apologies, Lynn.  Thank you for your input here.

    The problem got a little more complex...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 20, 2017 at 9:48 am

    #1972940

  • RE: Help with aggregate function

    ger_serrano - Wednesday, December 20, 2017 7:34 AM

    Awesome Jeff!!.  Thanks a lot. I think the following query is also rdbms agnostic:
    with newtab...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 20, 2017 at 9:07 am

    #1972921

  • RE: SQL XML - Font colour in a case statement

    The problem is that we don't have access to your tables, so we cannot select from them, so we cannot insert into the table variable.  If I try to run...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 20, 2017 at 8:54 am

    #1972918

  • RE: SQL XML - Font colour in a case statement

    I have your answer and will provide it once you provide consumable data.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 20, 2017 at 8:03 am

    #1972904

  • RE: SQL XML - Font colour in a case statement

    INSERT/SELECT statements do us no good, because we don't have access to the tables in the SELECT part of the statement.  You need to provide sample data as INSERT/VALUES statements. ...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    December 20, 2017 at 8:01 am

    #1972903

Viewing 15 posts - 1,411 through 1,425 (of 4,085 total)