No I did not got such issue.

You are saying convesion error message.Can you Cast ID column to Int

E.g.

Select Cast(ID) ,Name From Client

This may solve your problem.

Regards

Sagar

No Order by can not be done using paramerter of SP. For this you need to select these parameters as column and then you can use for ordering purpose.

Could you...