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...

Remi is spot on both in statement and method suggested... you still don't need a cursor to do that.  Do like remi recommended...

First, you have a major bug in the code you posted... you don't create a value for @GenInfo_ID variable which means that you are populating the GenInfo_ID column of the...

Serqiy is correct... is the stuff you putting into @List available in a table anywhere?  If so, we can resolve the whole table instead of using RBAR methods...

If you're talking about the method in the URL I provided and not the BOL solution, some indexes will certainly help once the tree for the whole DB is constructed. ...