Forum Replies Created

Viewing 15 posts - 1,216 through 1,230 (of 4,085 total)

  • RE: Deriving group members from nested groups

    Chrissy321 - Wednesday, February 21, 2018 3:28 PM

    Thanks Drew. Let me clarify if I can.

    I would like to build a groups data...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 22, 2018 at 9:51 am

    #1980792

  • RE: Deriving group members from nested groups

    It's not entirely clear what you are trying to accomplish, but I would restructure your tables.  GroupMembers should be a link between groups and individuals ONLY.  It should not contain...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 21, 2018 at 2:03 pm

    #1980684

  • RE: Convert WHILE LOOP TO CTE

    kevin_nikolai - Wednesday, February 21, 2018 8:23 AM

    Thanks, works for column     Net Losses Prev 12 months,
    Now to get it working...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 21, 2018 at 11:34 am

    #1980662

  • RE: SSRS report scrollbar on the right is for the whole page not just the report - looking to have column headings fixed

    chris.rogers 77037 - Wednesday, February 21, 2018 7:33 AM

    lklein - Thursday, October 30, 2014 2:35 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 21, 2018 at 7:39 am

    #1980617

  • RE: Convert WHILE LOOP TO CTE

    It looks like the following will work.

    SELECT SUM([Net Loss]) OVER( PARTITION BY ADM_RISK_GRADING_ORG_UNIT_ID, ADM_EVENT_TYPE_ID, ADM_CAUSE_TYPE_ID ORDER BY [Effect Date YYYYMM] ROWS BETWEEN 12 PRECEDING AND 1...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 20, 2018 at 3:08 pm

    #1980563

  • RE: Looking to sort two queries by Date, Time

    chef423 - Tuesday, February 20, 2018 2:02 PM

    Does this help?

    Invalid object name 'Permissions'.
    Invalid object name 'Inventory_Exceptions'.
    Invalid object name 'Inventory'.

    You are also...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 20, 2018 at 2:25 pm

    #1980551

  • RE: Again, trying to use a value with the max Close Date

    jeffshelix - Monday, February 19, 2018 12:22 PM

    UPDATE t
    SET Elig_Flag = P.ELIGIBILITY_FLG
    FROM #TEMP_STP t
    CROSS APPLY (
     SELECT P.ELIGIBILITY_FLG
     FROM [SOLICIT].[GTM_DOC_PROD]...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 19, 2018 at 12:29 pm

    #1980326

  • RE: Line chart from table containing static values

    Innerise - Friday, February 16, 2018 8:54 AM

    Hi
    I am following a similar process. However, I don't want to do any aggregation, as...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 16, 2018 at 9:11 am

    #1980087

  • RE: Decimal place in SQL

    IQ1 - Thursday, February 15, 2018 3:28 PM

    yes actually my bad the rounding logic is to be applied to all cases but...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 16, 2018 at 7:32 am

    #1980063

  • RE: Decimal place in SQL

    IQ1 - Thursday, February 15, 2018 1:56 PM

    The logic is the same for all except that when there are leading zeros ,...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 15, 2018 at 2:02 pm

    #1980001

  • RE: Help me with for Xml path()

    Thom A - Thursday, February 15, 2018 10:18 AM

    Little more ugly (well, a lot more), someone might have a better answer,...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 15, 2018 at 12:40 pm

    #1979981

  • RE: Count(*) with LIKE

    TheSQLGuru - Thursday, February 15, 2018 11:10 AM

    drew.allen - Thursday, February 15, 2018 8:01 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 15, 2018 at 11:30 am

    #1979968

  • RE: Help me with for Xml path()

    You're trying to do everything in one subquery.  You need to break it out into multiple subqueries.


    WITH XML_Names AS
    (
        SELECT DISTINCT Xml_name
        FROM #temp
    )

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 15, 2018 at 9:41 am

    #1979940

  • RE: Count(*) with LIKE

    usererror - Thursday, February 15, 2018 8:15 AM

    @jackie Lowery - At this point, I don't know the OVER command, yet.  My full query...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 15, 2018 at 8:49 am

    #1979931

  • RE: Datediff and divide by zero problem

    Jackie Lowery - Wednesday, February 14, 2018 8:56 PM

    Wouldn't you want to use a case statement like this to divide by 1...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 15, 2018 at 8:12 am

    #1979915

Viewing 15 posts - 1,216 through 1,230 (of 4,085 total)