Forum Replies Created

Viewing 15 posts - 916 through 930 (of 4,085 total)

  • RE: Identifying NEW/RETAIN/LOST unique_id

    alexander.lummer - Friday, September 14, 2018 9:36 AM

    I have a dynamic process that adds months and assess whether the account/product combination unique...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 14, 2018 at 9:55 am

    #2005799

  • RE: Are the posted questions getting worse?

    Jeff Moden - Thursday, September 13, 2018 8:09 PM

    Heh... must be one of those people that think that "Just because you...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 14, 2018 at 8:53 am

    #2005784

  • RE: Identifying NEW/RETAIN/LOST unique_id

    Most people are hesitant to open up documents posted by random strangers.  Please provide sample data as outlined in the first link in my signature.  You also haven't mentioned how...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 13, 2018 at 2:37 pm

    #2005684

  • RE: Are the posted questions getting worse?

    Jeff Moden - Thursday, September 13, 2018 11:57 AM

    But it's fast, right? :D:D:D

    It took almost 16 minutes to copy about 80K...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 13, 2018 at 2:32 pm

    #2005683

  • RE: Are the posted questions getting worse?

    OMG.  I'm working on a stored procedure that references an EAV table and it has 73 separate subqueries in a single SELECT statement to pull values out of the EAV...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 13, 2018 at 11:44 am

    #2005650

  • RE: Stored Procedure using WITH

    thunter 5669 - Thursday, September 13, 2018 7:46 AM

    Thank you for your help I was able to get the query to run...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 13, 2018 at 7:55 am

    #2005591

  • RE: CrossTab in SQL

    Joe Torre - Wednesday, September 12, 2018 6:09 PM

    Stored procedures do return select statements so you options are a stored procedure or...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 13, 2018 at 7:48 am

    #2005588

  • RE: Stored Procedure versus SQL In Report

    Gordon Barclay - Thursday, September 13, 2018 3:58 AM

    Scott Murray-240410 - Wednesday, April 6, 2011 5:32 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 13, 2018 at 7:40 am

    #2005585

  • RE: If branch then 'HDQ CityName, State

    SELECT *,
        MAX(CASE WHEN [Headquarters or Branch] = 'Headquarters' THEN 'HDQ, and the city of ' + BusinessCity + ', ' + State' END) OVER( PARTITION BY CompanyName)...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 12, 2018 at 3:20 pm

    #2005522

  • RE: If branch then 'HDQ CityName, State

    NewBornDBA2017 - Wednesday, September 12, 2018 3:02 PM

    I have a table and a user requested a data and he wants me to...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 12, 2018 at 3:12 pm

    #2005516

  • RE: XML Workshop 26 – SELECT * FROM XML

    Pagan DBA - Wednesday, September 12, 2018 1:54 PM

    I need the XMLTable function desperately. I tried downloading it from the link provided...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 12, 2018 at 2:27 pm

    #2005502

  • RE: Updating in duplicate records

    souLTower - Wednesday, September 12, 2018 10:01 AM

    Here's one way to do it

    -- Use a common table expression to find...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 12, 2018 at 12:33 pm

    #2005487

  • RE: SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds

    mchitturi - Wednesday, September 12, 2018 9:46 AM

    We added additional temp data files to match our 8 cores. We were expecting...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 12, 2018 at 12:25 pm

    #2005484

  • RE: Select Max dates which lower than current date

    laurie-789651 - Wednesday, September 12, 2018 8:31 AM

    How about this:


    SELECT KidID, MAX(EndDate) as MaxEndDate
    FROM [dbo].[Payments]
    WHERE EndDate < GETDATE()
    GROUP BY KidID;

    That...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 12, 2018 at 9:55 am

    #2005453

  • RE: case when xxx = anything

    Assuming that ACT_Status and Status are not nullable, this should work.

    select      s.[Status], count(a.ACT_Status) [Count], s.[Rank]
    from        [(local)\ISYS].Intelligent.dbo.vwStaffStatus2 s left join
                    [(local)\ISYS].Intelligent.dbo.vwStaffDayActivity a on s.[Status] IN...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    September 12, 2018 at 9:49 am

    #2005451

Viewing 15 posts - 916 through 930 (of 4,085 total)