Forum Replies Created

Viewing 15 posts - 1,351 through 1,365 (of 4,085 total)

  • RE: Using IN and Case When splitting Numeric values

    Joe Torre - Tuesday, January 16, 2018 12:39 PM

    You will need to use dynamic SQL.

    DECLARE @sql nvarchar(4000);
    SET @sql =
    'WITH CTE_Base
    AS...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 16, 2018 at 1:18 pm

    #1976049

  • RE: Date Calendar

    Sean Smith (SSC) - Monday, January 15, 2018 9:34 PM

    shawnmandel - Monday, January 15, 2018 4:04 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 16, 2018 at 12:47 pm

    #1976046

  • RE: GROUPING

    Marcia J - Monday, January 15, 2018 5:16 PM

    GDownie - Monday, January 15, 2018 2:54 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 16, 2018 at 12:37 pm

    #1976041

  • RE: SQL Server equivalent of adding hours to a date field (in oracle) using Trunc

    ryanbesko - Friday, January 12, 2018 2:43 PM

    QuietCoder - Friday, January 12, 2018 2:20 PM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 12, 2018 at 2:56 pm

    #1975798

  • RE: Calculate Days between Teams

    Are you really on SQL 2008?  This is a lot easier on SQL 2012.

    Also, using an rCTE for calendar generation is extremely inefficient.  Here is a better approach...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 12, 2018 at 1:54 pm

    #1975786

  • RE: Are the posted questions getting worse?

    :crazy:
    I had to reset my windows password today and kept having troubles.  It turns out that the 12-character password that I had entered was TOO LONG.  REALLY!?!  12...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 12, 2018 at 10:21 am

    #1975757

  • RE: Split data into two tablix

    It sounds like you want to use NTILE instead of MOD.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 11, 2018 at 11:34 am

    #1975579

  • RE: Divide column data into equal parts

    Jeff Moden - Thursday, January 11, 2018 8:40 AM

    Also, let's consider that you don't have SSRS installed anywhere and you needed to do something like this.  Would you stand up...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 11, 2018 at 9:48 am

    #1975539

  • RE: Row inserts for groups of rows (Totals for groups of like data).

    As I mentioned, there are two sources of NULLs.  You could use the brute force method and treat all NULLs the same or you could use a more finessed approach...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 11, 2018 at 8:26 am

    #1975515

  • RE: Divide column data into equal parts

    Jeff Moden - Wednesday, January 10, 2018 7:11 PM

    drew.allen - Wednesday, January 10, 2018 9:17 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 11, 2018 at 7:33 am

    #1975496

  • RE: Difficulties with the WHERE clause

    mpdillon - Wednesday, January 10, 2018 1:17 PM

    I am interacting with an ERP database. The field, Ord_No in all the tables in...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 10, 2018 at 1:38 pm

    #1975383

  • RE: Row inserts for groups of rows (Totals for groups of like data).

    bswhipp - Wednesday, January 10, 2018 11:53 AM

    drew.allen - Wednesday, January 10, 2018 11:39 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 10, 2018 at 1:32 pm

    #1975380

  • RE: Row inserts for groups of rows (Totals for groups of like data).

    bswhipp - Wednesday, January 10, 2018 11:25 AM

    Drew, One other question Is there a way in the code to...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 10, 2018 at 11:39 am

    #1975355

  • RE: Divide column data into equal parts

    He has a columnar report that fills the columns top-to-bottom then left-to-right.  He wants to change the order of the fill to left-to-right then top-to-bottom.

    This is a presentation...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 10, 2018 at 9:17 am

    #1975316

  • RE: Divide column data into equal parts

    This appears to be a presentation issue and is best handled in the presentation layer.  Is there a compelling reason for trying to do this in the database layer?

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 9, 2018 at 2:10 pm

    #1975171

Viewing 15 posts - 1,351 through 1,365 (of 4,085 total)