custom sort

#1

I have an application that helps the client retrieve data from the DB. It
allows the client to enter parameters for us to create the sql. and the
client doesn't have to understand the data model.

The request that came in recently has thrown me for a loop.
The client want to be able to customize the return sort order. for example
order by:
due_date desc,
(object_name like 'C%', followed by object_name like 'N%, followed by
object_name like 'F%', followed by object_name like 'S%'),
object_id asc

is there a way we can create a comparable enumeration and use it in the sort?

#2

Not that I know of.

Sorry

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

"stormguts" <stormguts (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have an application that helps the client retrieve data from the DB. It
allows the client to enter parameters for us to create the sql. and the
client doesn't have to understand the data model.

The request that came in recently has thrown me for a loop.
The client want to be able to customize the return sort order. for
example
order by:
due_date desc,
(object_name like 'C%', followed by object_name like 'N%, followed by
object_name like 'F%', followed by object_name like 'S%'),
object_id asc

is there a way we can create a comparable enumeration and use it in the
sort?

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

custom sort

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

custom sort - 10-06-2004 , 11:05 AM

Re: custom sort - 10-06-2004 , 01:50 PM