select datepart( hour, cdr.fsl_dstIdDate ) as byHour, format( fsl_dstIdDate, 'hh tt' ) as byHourFullText, convert( varchar, cdr.fsl_dstIdDate, 101 ) as mappedDate, sum( case when dateDiff( n, dst.dateCreated, cdr.fsl_dstIdDate ) <= 1 then 1 else 0 end ) newRecord, sum( case when dateDiff( n, dst.dateCreated, cdr.fsl_dstIdDate ) > 1 or dst.dateCreated is null then 1 else 0 end ) existingRecord from tbl_CDR_Distributors cdr with (nolock) inner join tbl_DST_Distributors dst with (nolock) on dst.dstid = cdr.fsl_dstId inner join tbl_FSPRO_Members mem with (nolock) on mem.fspro_userId = cdr.fsl_dstIdBy where nullif( cdr.fsl_dstIdDate, '' ) is not null and cdr.fsl_dstId > 0 and convert( datetime, convert( varchar, cdr.fsl_dstIdDate, 101 )) >= and convert( datetime, convert( varchar, cdr.fsl_dstIdDate, 101 )) < and mem.email = and mem.email in ( ) and cdr.ownerId = and cdr.fsl_tablecode = group by datepart( hour, cdr.fsl_dstIdDate ), format( fsl_dstIdDate, 'hh tt' ), convert( varchar, cdr.fsl_dstIdDate, 101 ) order by datepart( hour, cdr.fsl_dstIdDate ) for json auto, include_null_values