Forum Replies Created

Viewing 15 posts - 871 through 885 (of 4,086 total)

  • RE: I need help with SQL queries

    below86 - Tuesday, October 2, 2018 12:33 PM

    Just added a few tweaks:
    DECLARE @StartDate DATE;
    DECLARE @EndDate DATE;
    DECLARE @PrevYearStart DATE;
    DECLARE @PrevYTDEnd DATE;
    DECLARE...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    October 2, 2018 at 12:57 pm

    #2007776

  • RE: sql server does not seem to have an equivalent of Oracle %ROWTYPE ?

    Sue_H - Tuesday, October 2, 2018 11:44 AM

    But isn't SYSDATE + 1/24/60 an intuitive way to add a minute?  🙂

    Sue

    I don't...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    October 2, 2018 at 12:12 pm

    #2007759

  • RE: I need help with SQL queries

    Declare @StartDate date = '01-01-2018', @EndDate date = '09-30-2018'

    DECLARE @PrevYearStart DATE = DATEADD(YEAR, -1, @StartDate),
        @PrevYearEnd DATE = DATEADD(YEAR, -1, @EndDate),
        @MonthStart DATE = DATEADD(MONTH,...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    October 2, 2018 at 11:55 am

    #2007757

  • RE: Can i sort a cross tab horizontally?

    I think it's much simpler.  You've posted in an SSRS forum, so presumably you are doing this in SSRS.  I also presume that you are using a matrix.  In your...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    October 1, 2018 at 3:28 pm

    #2007615

  • RE: Change Logs

    Never mind.  The OP is asking for the discussion to take place here instead of where I was pointing to.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    October 1, 2018 at 2:00 pm

    #2007594

  • RE: Delete data with sliding date window

    sgmunson - Monday, October 1, 2018 1:18 PM

    The delete you've coded does ALL the needed deletes in one fell swoop, and having a...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    October 1, 2018 at 1:51 pm

    #2007591

  • RE: Script to delete a file if already exists in SSIS

    I would use a file system task instead.  No need to reinvent the wheel.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    October 1, 2018 at 10:19 am

    #2007538

  • RE: Need help in writing Query

    Prakash-485822 - Monday, October 1, 2018 12:47 AM

    I got the required output. Please find below query
    select
    a.RequestId,a.ResolverGroup,a.datecreated RecvdDate
    ,lead(a.datecreated) over(order by a.datecreated) processdate Processdate
    from...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    October 1, 2018 at 7:48 am

    #2007497

  • RE: How to query record between occurances

    Mike01 - Friday, September 28, 2018 1:32 PM

    I think your example isn't good, but it looks like you're looking for the first...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 28, 2018 at 2:06 pm

    #2007410

  • RE: Are the posted questions getting worse?

    Michael L John - Thursday, September 27, 2018 12:40 PM

    Ray K - Tuesday, September 25, 2018 1:50...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 28, 2018 at 9:53 am

    #2007384

  • RE: Finding when date changes for customer in table

    mnovosel - Thursday, September 27, 2018 12:22 PM

    Worked my way through it and looks like I've got the solution more or less. ...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 28, 2018 at 7:55 am

    #2007370

  • RE: Identifying field value corresponding to MAX of another field value

    Why do you have parens around your query?

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 26, 2018 at 2:23 pm

    #2007159

  • RE: Select top issued, continued

    jeffshelix - Wednesday, September 26, 2018 9:02 AM

    Ok, now i need  to pull a specific number of entries from a table based...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 26, 2018 at 9:40 am

    #2007111

  • RE: Regex in Replace?

    ken.trock - Tuesday, September 25, 2018 12:27 PM

    Hello. I'm trying to turn something like '{1,2,3,4,5}' into '1,2,3,4,5'. I can't be certain that...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 25, 2018 at 12:31 pm

    #2006980

  • RE: Table with hyperlink

    That depends on what UI you are using to display the data.  Since you didn't state, I'm assuming you mean in SSMS.  SSMS is a development environment, and is not...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 25, 2018 at 7:41 am

    #2006894

Viewing 15 posts - 871 through 885 (of 4,086 total)