Forum Replies Created

Viewing 15 posts - 1,141 through 1,155 (of 4,085 total)

  • RE: Are the posted questions getting worse?

    And some people wonder why they never got a response: Vague Question: Complex Topic

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    July 13, 2018 at 12:31 pm

    #1997527

  • RE: Table design considerations help

    Yeah.  My thoughts are that you've been around long enough to know that that's not the way things work around here.

    Database design is too complex a topic for...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    July 13, 2018 at 12:15 pm

    #1997523

  • RE: Problem with concatenating columns and using that in a WHERE clause

    SELECT SERIALNUMBER, [DOB] , [FULLNAME]
    FROM CONTACT
    CROSS APPLY( VALUES(CONVERT(VARCHAR

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    July 13, 2018 at 8:47 am

    #1997475

  • RE: Problem with concatenating columns and using that in a WHERE clause

    j.clay 47557 - Friday, July 13, 2018 6:44 AM

    Hi all
    I'm currently having a couple of problems with the script below. What I'm...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    July 13, 2018 at 7:01 am

    #1997462

  • RE: Permission issue

    Phil Parkin - Thursday, July 12, 2018 8:57 AM

    Instead of 
    Alter table [invoice.invoice]
    try 
    Alter table invoice.invoice
    Those square brackets around the schema.table might be the...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    July 12, 2018 at 9:28 am

    #1997333

  • RE: Who Likes NULL?

    Dennis Q Miller - Wednesday, July 11, 2018 9:12 AM

    Jeff Moden - Wednesday, July 11, 2018 8:28...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    July 11, 2018 at 9:26 am

    #1997147

  • RE: Who Likes NULL?

    Matt Miller (4) - Tuesday, July 10, 2018 1:15 PM

    Lynn Pettis - Tuesday, July 10, 2018 12:38...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    July 10, 2018 at 2:50 pm

    #1997073

  • RE: SQL Query - Hourly Count

    Instead of having to enter the same formula multiple times, I used the CROSS APPLY to create a field that I could use instead.

    I also changed your query...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    July 10, 2018 at 2:46 pm

    #1997071

  • RE: script

    Diyas - Tuesday, July 10, 2018 2:10 PM

    pp source table -->select id,PPID,Name,Create_Date,Modified_Date, isactive from A.PP
    pp_old destination table.--> select id,PPID,Name,Create_Date,Modified_Date, isactive from A.PP_old

    With >...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    July 10, 2018 at 2:27 pm

    #1997068

  • RE: Need to display a column with deleted overlapping dates

    sanket.wagh7689 - Tuesday, July 10, 2018 1:21 PM

    Mike01 - Tuesday, July 10, 2018 10:51 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    July 10, 2018 at 1:41 pm

    #1997059

  • RE: how do i find a specific status, and only that status

    Lynn Pettis - Tuesday, July 10, 2018 12:40 PM

    So am I wrong to provide other alternatives?  Is so I will just go...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    July 10, 2018 at 12:58 pm

    #1997049

  • RE: SQL Query - Hourly Count

    Steve Jones - SSC Editor - Tuesday, July 10, 2018 9:44 AM

    Great point, Drew. In that case, you might want to build...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    July 10, 2018 at 12:08 pm

    #1997038

  • RE: Who Likes NULL?

    Lynn Pettis - Tuesday, July 10, 2018 9:31 AM

    So, what is the difference between:
    StartDate >= '2018-01-01' AND EndDate IS...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    July 10, 2018 at 10:27 am

    #1997020

  • RE: how do i find a specific status, and only that status

    Lynn Pettis - Tuesday, July 10, 2018 9:21 AM

    Here are two examples (and why test both MIN and MAX to be...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    July 10, 2018 at 9:34 am

    #1997006

  • RE: SQL Query - Hourly Count

    Also, it helps to know if you want to include hours where there is no data.  That would require a different approach to fill in the hours missing data.

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    July 10, 2018 at 9:13 am

    #1996989

Viewing 15 posts - 1,141 through 1,155 (of 4,085 total)