What's the scoop with sorting SQL Server dates?
Some sample data:

8/19/2002
8/07/2002
1/1/1000
12/12/2000
12/31/9999

Running a query against this data like:

Select theDate from theTable order by theDate

Returns an invalid sort order. Thanks for your help.

--
Dave Green | PremierStudios | 913.438.1004



-----Original Message-----
From: Ben Timby [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, August 21, 2002 6:38 PM
To: ActiveServerPages
Subject: RE: website statistics


 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I would not suggest an ASP app for WWW stats. You should get a log
parser. It will filter your HTTP logs, and give you stats. AnaLOG is a
good/free one.

Ben Timby
Webexcellence
PH: 317.423.3548 x23
TF: 800.808.6332 x23
FX: 317.423.8735
[EMAIL PROTECTED]
www.webexc.com 

- -----Original Message-----
From: Brett M. Spahr [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, August 21, 2002 1:10 PM
To: ActiveServerPages
Subject: website statistics



Does anyone know of a good, free asp app for tracking
website statistics?

- ---
You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To
unsubscribe send a blank email to %%email.unsub%%

-----BEGIN PGP SIGNATURE-----
Version: PGP 7.0.4

iQA/AwUBPWQdaPnby1cCm2Q8EQJKPgCgyITj7o7i/fbH/hkjs/ck7GGKz4YAoIrA
o9YZThzhrVV6g9laZxj6iwFg
=d+J3
-----END PGP SIGNATURE-----



---
You are currently subscribed to activeserverpages as:
[EMAIL PROTECTED] To unsubscribe send a blank email to
%%email.unsub%%


---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]

Reply via email to