Forum Replies Created

Viewing 15 posts - 781 through 795 (of 4,085 total)

  • RE: Inner joins

    aaron.reese - Tuesday, November 27, 2018 6:12 AM

    The one that freaks me out is the nested join syntax


    SELECT
          ...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 27, 2018 at 8:16 am

    #2014659

  • RE: Inner joins

    Jeff Moden - Wednesday, November 21, 2018 1:03 PM

    drew.allen - Wednesday, November 21, 2018 11:33 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 23, 2018 at 8:16 am

    #2014394

  • RE: Inner joins

    Jeff Moden - Wednesday, November 21, 2018 9:06 AM

    ScottPletcher - Monday, November 19, 2018 11:57 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 21, 2018 at 11:33 am

    #2014278

  • RE: Case when inside of partition by?

    I believe that this will give you what you want.  You can use either BINARY or CHAR as the intermediary data type.  BINARY is usually simpler, because you don't have...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 21, 2018 at 7:53 am

    #2014222

  • RE: call power point template in SSRS

    satishthota - Saturday, November 17, 2018 9:20 AM

    Hello,

    I have a requirement, how to call power point template in SSRS.

    Any...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 19, 2018 at 12:28 pm

    #2014018

  • RE: Need a distinct result set

    You will learn a lot more by doing your own homework rather than getting others to do it for you.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 15, 2018 at 8:40 am

    #2013683

  • RE: The Linux CoC

    Lynn Pettis - Wednesday, November 14, 2018 2:20 PM

    skeleton567 - Wednesday, November 14, 2018 1:01 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 15, 2018 at 8:12 am

    #2013667

  • RE: Are the posted questions getting worse?

    REALLY?!?!  Maybe it's because it's Friday.

    I'm having trouble logging into a system.  I wrote to the admin and told them I was having trouble logging in, mentioned that...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 9, 2018 at 1:09 pm

    #2013022

  • RE: see if row exists in another table but what if null

    Siten0308 - Friday, November 9, 2018 12:04 PM

    Hello

    hopefully this makes sense. i have 2 tables, a and b, and i am seeing...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 9, 2018 at 12:47 pm

    #2013019

  • RE: seperate data in 1 row

    You haven't given enough information for anyone to come up with a reasonable solution.  In fact, it looks like your "Good data" isn't so good. Based on the emails, I suspect...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 9, 2018 at 12:01 pm

    #2013010

  • RE: Today's Random Word!

    Revenant - Wednesday, November 7, 2018 12:34 PM

    below86 - Wednesday, November 7, 2018 7:29 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 7, 2018 at 12:45 pm

    #2012745

  • RE: How can I get a set Date and Time Range between Yesterday and Today?

    ScottPletcher - Tuesday, November 6, 2018 7:46 AM

    drew.allen - Tuesday, September 18, 2018 3:08 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 6, 2018 at 12:25 pm

    #2012604

  • RE: Using SUM() In CASE Statement / Best Practices

    mitzyturbo - Tuesday, November 6, 2018 10:25 AM

    Triangular Join - I knew there was a name for that (wrote my result set...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 6, 2018 at 11:49 am

    #2012591

  • RE: how to get rows from two datetime fields with hours on morning time.

    Jonathan AC Roberts - Tuesday, November 6, 2018 6:33 AM

    marcelo salgado - Monday, November 5, 2018 6:16...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 6, 2018 at 9:45 am

    #2012565

  • RE: get qtr,month and year from start date

    Using Lynn's code and replacing the code for the sample date with your actual table field.


    SELECT *
    , datepart(year,dateadd(month,11,StartDate)) as [FiscalYear]
     , datepart(quarter,dateadd(month,11,StartDate)) as...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    November 6, 2018 at 9:38 am

    #2012562

Viewing 15 posts - 781 through 795 (of 4,085 total)