WHERE CAST(CONVERT(VARCHAR,trndate,101)AS DATETIME) BETWEEN @DteFrmDate AND @DteToDate AND ex.ExcVarDomain IN (SELECT * FROM dbo.UdfEsSplitPrdCls(@VarEstoreList,'|'))
AND TrnVarFrmEid not like '%_@natl._%'
and TrnVarFrmEid not like '%_@chennaibazaar._%'
and TrnVarFrmEid not like '%_@diy._%'
and TrnVarFrmEid not like '%_@cbazaar._%'
In this we need to check email id should contain chat@cbazaar.com. but we given the condition 'and TrnVarFrmEid not like '%_@cbazaar._%''. Obviously it will not shown there. so kindly rearrange this statement to get chat@cbazaar.com and not other @cbazaar.com