Thanxs.

Hi Hemantjemmy,

Thanxs for your function. i already hav this function.

Well as i did not found any direct way to get my problem solved hence a did some work...

hi Chris,

I used your function but it gives me error on execution Invalid object name 'Numbers'.. Also could you please explain a bit about it.

Thanxs in...

Hi Chris,

thanxs for the solution.But this would only be applicable if Id's r fixed not for dynamically fetched ID's.

Actualy I have a Stored Procedure which...

hi Gail,

Thaxs for your prompt reply.

Acutaly order by will give me the result in ACS or DESC order. But in my case i need result in the order .... of...