Home Forums SQL Server 2005 SQL Server 2005 General Discussion help needed for sql query RE: help needed for sql query

  • February 5, 2013 at 2:13 pm

    #1584606

    This should work for you....

    select Customer, status, sum(datediff(dd, createddate, lastupdatedate))

    from #TempTable

    group by Customer, status

    order by customer