Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Date difff from two dates divide by count RE: Date difff from two dates divide by count

  • February 13, 2016 at 1:00 pm

    #1858606

    djreggaestyles (2/13/2016)

    count (claim_number) may noy work because, i want to divide the count of individual claims

    Just responding to the above without digging any deeper into the problem (so perhaps I am misunderstanding you) ... have you tried COUNT(DISTINCT claim_number) ?

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/