Great idea... thanks everyone...

Carl, thanks for the original idea that everyone seems to be hitting on.

Rog,

I appreciate the compliment.  A long time ago, I realized that the first step towards the "Sql excellence" you speak of is correct identification of the given problem...

Apparently, though,...

You mean just use a scheduled job?  Or is there some way to allow the user to start the job "indirectly"?

The one David was talking about is actually available in "Help" in Query Analyzer... it's also known as "Books OnLine".

Heh... did for me... data is pretty well broke...

Thanks for the info guys... like I said, I may have to reevaluate my position on where to store images.

Not sure why you have the first EndDate becoming a start date but whatever... the following will do what you ask for...

 SELECT Client_NHI, MIN(End_Date) AS StartDate, MAX(End_Date) AS EndDate
   FROM...

Nope... I'm pretty well spammed out on RAC.  How about posting the T-SQL solution that it's supposed to replace?

Would have been a bit helpful to know that up front.

First, whatever you do... do NOT use dynamic SQL for this because you are allowing the user to type whatever...

Heh... if you run into a "toughy", c'mon back... lot's of good folks waiting in the wings...

And, don't use recursion to solve this... SQL Server 2000 cannot go "N" levels... it's limited to only 32 levels and then "BOOOOOOM!"

Based on the original code you posted, you shouldn't have a problem...

The @bfr_tag    holds 634 characters.

@general_notes holds a max of 2500 characters.

@day_notes      holds a max of 2500 characters.

@nite_notes      holds a...

Thank you for the feedback...

If you are still having problems or need to use "row_number" (now that we know you are using 2k5) instead of an Identity column, please post...

Actually, they did... nice red/white/and blue google with a bald eagle and the whole shootin' match.  I believe Google logins sense which country you are in to allow for if...

Thanks for the info Michael... I'm not much of a "web guy"... what makes it difficult to use "file shares" in the Web world... asking because I don't know and...