SEO

#1 (**permalink**) 02-28-2008, 09:25 AM

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

#2 (**permalink**) 02-28-2008, 09:25 AM

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
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Using select on output of stored procedures