Hi All,

Thanks for your inputs. I am attaching the query execution plan. Please tell me as what is going on wrong.

There is no NULL value in...

Hi,

PLease find the execution plan attached.

Select CL.RTCODE [Route Code],MR.RtName [Route Name], CASE MR.TMode WHEN 'V' THEN 'Van'...

Hi Ryan,

I have many procedures using dynamic sqls. And my main problem comes when the IN clause is used. A.ClOffCd IN (' + @ClOffCd + ') AND...