ADSM-L

Re: select statement similar to query client schedules

2003-03-20 15:09:01
Subject: Re: select statement similar to query client schedules
From: "Stapleton, Mark" <stapleto AT BERBEE DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 20 Mar 2003 14:02:43 -0600
From: Joni Moyer [mailto:joni.moyer AT HIGHMARK DOT COM] 
> I have a user that would like the output of the query the 
> schedule event records for the users to be sorted in 
> alphebetical order by the node name instead of the start time 
> of the output.  Is there a select statement that can pull out 
> the same info, but sort it by node name, actual start, 
> schedule name and status?  Thanks!

Sure. Onto the end of your select statement, add

        order by node_name,actual_start,schedule_name,status

--
Mark Stapleton (mark.stapleton AT berbee DOT com) 

<Prev in Thread] Current Thread [Next in Thread>