Forum Replies Created

Viewing 15 posts - 1,876 through 1,890 (of 4,086 total)

  • RE: Mulitiple Data Sets

    Sorry, didn't realize this was in SSRS.  You don't want five separate datasets.  You should either be creating two datasets (one for the main report and one for the grant...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 16, 2017 at 11:50 am

    #1928921

  • RE: Non-ANSI equal join - SQL 2012

    Jeff Moden - Wednesday, February 15, 2017 9:22 PM

    Lynn Pettis - Wednesday, February 15, 2017 10:08 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 16, 2017 at 11:16 am

    #1928910

  • RE: The,,classroom,,is,,more,,than,,a,,

    Reported as spam.

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 16, 2017 at 10:57 am

    #1928904

  • RE: Mulitiple Data Sets

    It depends on what you mean by "link".  The obvious options are JOIN or UNION.  If you want something more specific than that, you're going to need to provide more...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 16, 2017 at 10:55 am

    #1928902

  • RE: textbooks outlining and the visual

    Reported as spam.

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 14, 2017 at 3:14 pm

    #1928507

  • RE: SQL Query to find number of changes in ParamValue column per Paramaterid

    ;
    WITH param_changes AS
    (
        SELECT *, CASE WHEN LAG(ParamValue) OVER(PARTITION BY ParameterID ORDER BY VersionID) <> ParamValue THEN 1 ELSE 0 END AS change
        FROM IntegrationParameters
    )

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 14, 2017 at 3:09 pm

    #1928506

  • RE: Best academic sets

    Reported as spam.

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 13, 2017 at 4:21 pm

    #1928247

  • RE: The arabic lights

    Reported as spam.

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 13, 2017 at 4:21 pm

    #1928246

  • RE: Running date update

    The problem with that solution is that it requires a JOIN which is expensive.  You can do it without a JOIN.

    ;
    WITH T_Dates AS
    (
        SELECT...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 13, 2017 at 4:14 pm

    #1928243

  • RE: Using Count to compile for each unique CustomerID

    Zososql - Wednesday, February 8, 2017 5:32 PM

    I want to create a column whereas I will count each instance a customerid has...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 10, 2017 at 9:39 am

    #1927830

  • RE: Entering Data into a Field Based on Other Records

    John Roy Ellis - Tuesday, February 7, 2017 2:44 PM

    Thanks, for the quick response!
    Unfortunately, I'm getting errors upon running this. 
    Is any...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 8, 2017 at 9:01 am

    #1927359

  • RE: 2 consecutive timestamps greater than 4 hours

    Lord Slaagh - Tuesday, February 7, 2017 10:43 AM

    Hello SSC,

    I posted this question earlier yesterday, but I don't think I asked the...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 7, 2017 at 2:13 pm

    #1927207

  • RE: The Master Stroke

    Reported as spam.

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 7, 2017 at 2:07 pm

    #1927205

  • RE: Do not imagine that there is any bird more

    Reported as spam.

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 7, 2017 at 2:06 pm

    #1927204

  • RE: SSIS Delete rows in EXCEL workbook

    cbrammer1219 - Tuesday, February 7, 2017 10:19 AM

    You're funny

    This is a free forum and we are all volunteers here.  Most of us...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    February 7, 2017 at 10:30 am

    #1927147

Viewing 15 posts - 1,876 through 1,890 (of 4,086 total)