All queries are now in the form of stored procedures. It makes it easier for them and for us.:-)

I think it's an easy way for them to shift the blame from themselves. Especially this developer who completely hates Microsoft and complains every time something goes wrong. He was...

Hi Vijaya,

It does get executed last but the behavior of the ORDER BY does not actually work the way you would expect it to work when prefixing the table alias....

Thank you so much! I appreciate the help.

Hi Grant,

Thanks for responding. Dropping the table identifier does work as the sort to the converted field. My question is why does it ignore the table designation on the ORDER...

Yes it is.

Hi Gail,

Thanks for the quick response. Now I just want to clarify 1 point that I don't quite understand:

On the original query, the ss.[Start_Date] identifier sorts by the converted value...