Home Forums SQL Server 2014 Development - SQL Server 2014 Early to development RE: Early to development

  • December 22, 2017 at 7:50 am

    #1973263

    SELECT
         Account,
         ShareType1 = MAX(CASE WHEN ShareType = 1 THEN 'Y' ELSE 'N' END)
    FROM #Account
    GROUP BY Account

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA