Forum Replies Created

Viewing 15 posts - 691 through 705 (of 4,086 total)

  • RE: How to insert multiple records from fields in select record

    You don't need the CASE expression.

    SELECT o.NameRecord,
        ca1.value1,
        ca1.value2,
        ca1.valueType + ' has changed from ' + ca1.value1 + ' to ' +...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 30, 2019 at 12:43 pm

    #2020617

  • RE: How to insert multiple records from fields in select record

    ScottPletcher - Wednesday, January 30, 2019 8:37 AM


    INSERT @TestTable2
    (
        NameRecord,
        SingleName
    )
    SELECT ca1.*
    FROM @TestTable
    CROSS APPLY (
        VALUES(ID, NameRecord,...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 30, 2019 at 8:48 am

    #2020568

  • RE: Equivalent of 'DECODE' in sql

    Jonathan AC Roberts - Tuesday, January 29, 2019 5:15 AM

    rachit.agarwal2011 - Tuesday, January 29, 2019 4:40 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 29, 2019 at 10:23 am

    #2020461

  • RE: Incremental load based on ID and Date

    koti.raavi - Tuesday, January 29, 2019 9:34 AM

    drew.allen - Tuesday, January 29, 2019 9:22 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 29, 2019 at 10:01 am

    #2020455

  • RE: Calculate daily meeting times for each employee

    naveed.tuf - Tuesday, January 29, 2019 9:42 AM

    My thinking of this was that I needed a query that would:

    Choose the lowest...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 29, 2019 at 9:54 am

    #2020453

  • RE: Question on grouping

    Thom A - Tuesday, January 29, 2019 9:07 AM

    drew.allen - Tuesday, January 29, 2019 8:58 AM

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 29, 2019 at 9:37 am

    #2020448

  • RE: Incremental load based on ID and Date

    Depending on what you are loading you should look at a LEFT OUTER JOIN or an EXCEPT.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 29, 2019 at 9:22 am

    #2020438

  • RE: Question on Grouping -Working number of days

    nadeem161 - Tuesday, January 29, 2019 9:10 AM

    Steve Jones - SSC Editor - Tuesday, January 29, 2019...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 29, 2019 at 9:20 am

    #2020435

  • RE: Question on Grouping -Working number of days

    They say that a picture is worth a thousand words, but not in the case of data.  Actual code is worth a thousand pictures.  Please provide sample data and expected...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 29, 2019 at 9:17 am

    #2020434

  • RE: Question on grouping

    ScottPletcher - Tuesday, January 29, 2019 8:07 AM

    It just seems less clear to me.  And that wouldn't count null values.
    SUM(CASE WHEN...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 29, 2019 at 8:58 am

    #2020428

  • RE: Get count for changed value

    fahey.jonathan - Monday, January 28, 2019 4:48 PM

    I'll present two methods that I found to get the data.  Thanks for posting the...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 29, 2019 at 8:15 am

    #2020417

  • RE: Question on grouping

    ScottPletcher - Monday, January 28, 2019 4:01 PM

    It's more common to use SUM(... THEN 1 ELSE 0 END), rather than COUNT,...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 28, 2019 at 4:14 pm

    #2020361

  • RE: Question on grouping

    thomas.miller1 - Monday, January 28, 2019 2:53 PM

    Not sure I understand what you mean by put the COUNT() outside the CASE...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 28, 2019 at 4:08 pm

    #2020359

  • RE: Are the posted questions getting worse?

    Got back from a meeting this morning to discover that I suddenly had a second meeting starting immediately.  Someone had scheduled me for a meeting with less than 10 minutes...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 25, 2019 at 9:46 am

    #2020134

  • RE: CONVERT COLUMN VALUES TO COMMA SEPARATED ONE ROW VALUE..

    repalaa - Thursday, January 24, 2019 1:29 PM

    ColdCoffee - Friday, March 2,...

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

    January 24, 2019 at 2:12 pm

    #2020034

Viewing 15 posts - 691 through 705 (of 4,086 total)