Declare @SQL nvarchar(4000) Set @SQL = ' Select Left(' +Case @LookupNumber When 0 Then 'A' When 1 Then 'B' When 2 Then 'C' End + 'Number,' +Cast(@Length as varchar(2)) +') StartofNumber, Count(*) TotalCalls, Sum(Case Duration When 0 then 0 Else 1 End) TotalConnectedCalls, Sum(Duration)/60 Minutes From vwCDRSuspense200601 With (Nolock) Where Carrierid = @CarrierId and Productid = @ProductId and errornumber = 2020 And Group by Left(' +Case @LookupNumber When 0 Then 'A' When 1 Then 'B' When 2 Then 'C' End + 'Number,' +Cast(@Length as varchar(2)) +') Order By StartofNumber' exec sp_executesql @SQL,N'@ProductId smallint, @CarrierId smallint', @ProductId, @CarrierId
Where
Group By
Where Carrierid = @CarrierId and Productid = @ProductId and errornumber = 2020 And Group by Left
And
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)