Hi Guys,

We (me and my DBA) came up with nice solution and it give me result in 0.5 second.

Appreciate your concern.

Thanks

From

Panther

I understand Mr/Ms 10 century. I thought It will some patch will resolve my issue.

Here is detail information:

Select * from tblA where ((rtrim(ltrim(Stats)) <> 'Closed' and convert(datetime, case when isdate(Pdate)=1...