This I don't know about. The default order is the order the data was
INSERTED in. Thats typically calldate for me. A simple order by
should work as well:
Select * From Calls
Order By CallDate
> 2. I can change the default horizontal listing order of columns in
> this table without causing any problems, right?
> (NASIdentifier, NASPort, AcctSessionID, etc. --> CallDate,
> Username, Ascenddatarate, etc.)
Yes, thats fines. You can also just change your select order. Thats
Select NASIdentifier, NASPort, AcctSessionID, CallDate, Username,
Order By NASIdentifier, NASPort
> 3. These columns have always had "(null)" in them. Can I "safely"
> eliminate these from the script before running it? What do
> they represent?
> UserService, LoginService, LoginHost, AcctTerminateCause,
> NASPortType, NASPortDNIS
Yes, that should be fine.
-- Dale E. Reed Jr. (firstname.lastname@example.org)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com