select mfrName, sum( d0 ) as D0, sum( d7 ) as D7, sum( d14 ) as D14, sum( d30 ) as D30, sum( d60 ) as D60, sum( d90 ) as D90, sum( d120 ) as D120, sum( queueLength ) as queueLength from tbl_1FS_MappingQueueDashboardByMfr with (nolock) where 1 = 1 and weekEndingDate = and linkLevel = group by mfrName for json auto, include_null_values