could you post the stored procedure?
--
Jack Vamvas
___________________________________
Advertise your IT vacancies for free at -
http://www.ITjobfeed.com
"David" <david.goodyear@gmail.com> wrote in message
news:1174051740.176443.151470@b75g2000hsg.googlegr oups.com...
> Hi all,
>
> We have a stored procedure that does some embedded Selects, and some
> maths in the selects. The output is a table.
>
> I cant for the life of me, with google searching work out how to
> select the results, so i can apply an order to the table once the
> procedure generates it.
>
> The only way i can see of doing this is to pass nasty variables in
> saying sortbycol1 then set it to true or false.
>
> Please help, so i can do it nicely
>
> Thanks in advance
>
> David
>