Adding to John's cool suggestion, you might want to package this into a re-usable user-defined function that you can include wherever you need.  Something like:

CREATE FUNCTION dbo.fnStringCount (...

Maybe I'm missing something, but won't "SELECT TOP 1 actiondatetime, actionstatus FROM #tmp ORDER BY actiondatetime DESC" do the trick?  The following yields "2005-03-03, Action 3" as the result...  Steve

CREATE TABLE...

Just a WAG but do you maybe have to set the encoding for the FORM tag in your ASP page?  Entering "html form encoding chinese" in Google yields some info,...

To retrieve a user's domain name you can use the WNetGetUser API call

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wnet/wnet/wnetgetuser.asp

Wow... 230+ NULL columns to me screams for some data normalization.  Pull those columns that are typically NULL out into their own tables (one or more) with the same PK...

I think he meant that the ability to sort dates and get date differences is built-in, not the ability to convert to Julian dates.  For what it's worth, WRT Julian...

I would think you'd want to store the calendar date and compute the Julian date.  I'm sure you can find a user-defined function (UDF) that'll do it.  If you wanted,...

Why use a datatype with the Command object at all?  Below is an example of how I use the Command object all the time:

With cmd

   .ActiveConnection = myConn

   .CommandType =...

Sweet!  Thanks PW, that seemed to do the trick.

I forgot one important part... items may be deleted but still need to be included in the resultset.  So modifying my dataset a bit...

AAA   Nov-04  ITEM_AAA_NAME

CCC   Dec-04  ITEM_CCC_NAME

February 4, 2005 at 10:05 am