DECLARE @Cat varchar(15), @Channel varchar(2), @Aging varchar(15)SELECT @Cat = 'Termed',@Channel = 'BE', @Aging = 'NEW'--0:01SELECT RepQBL FROM report.dbo.compliance_termedWHERE compliance_cat='Termed' and Left(RepQBL,2)='BE'AND (Aging = 'New')group by RepQBLorder by RepQBL--0:01EXEC('SELECT RepQBL FROM Report.dbo.Compliance_TermedWHERE Compliance_Cat='''+@Cat+''' and Left(RepQBL,2)='''+@Channel+'''AND (Aging = '''+@Aging+''')group by RepQBLorder by RepQBL')--0:05SELECT RepQBLFROM Report.dbo.Compliance_TermedWHERE Compliance_Cat=@Cat and Left(RepQBL,2)=@ChannelAND (Aging = @Aging)group by RepQBLorder by RepQBL