Consider a function, like below...

CREATE FUNCTION myConcantenate

 (@Id int)

RETURNS varchar(8000)

AS

BEGIN

DECLARE @RetStr varchar(8000)

SELECT @RetStr = COALESCE(@RetStr + ', ', '') + SomeTable.SomeCharColumn

FROM SomeTable

WHERE SomeTableId = @Id

RETURN @RetStr

END

GO

Then your select would look...

Rob,

Is there any reason that you cannot duplicate the procedure at the other sites and then implement a method to determine which procedure is called, either local or remote?

I don't...

I believe there is a typo here, and "Products" should actually be @Products.

However, I believe a better solution is to use @@ROWCOUNT.

Select @HowManyProducts = @@ROWCOUNT

Why hit that table again if...

The query posted above by Erik will certainly give you the results that you have posted, but are those the results you really want?

I am thinking that you really only...

I don't know the full use of your UDF, so I don't know if it is safe to make a change to the UDF itself.  If it is safe, I...

I think the problem here, is not in having a history table or in how order details are being tracked, but rather in allowing products to change w/o being a...

Query hints have to be added to the source code, so that isn't an option for you.

The link with info on removing a service pack (patch) was in a post...

In regards to removing a service pack, take a look at this link http://support.microsoft.com/default.aspx?scid=kb;en-us;314823&sd=tech

In regards to MAXDOP, unless you have the specific information from the query plan that indicates...

If your system recognizes 4 processors, I would try setting the MAXDOP to 1.  If it only sees it as 2 (depending on hyperthreading/dual cores, etc.) I wouldn't change it,...

The only thing that stands out about the settings you posted above is the Min Server Memory being 2157.  At the moment my brain is failing me, and I can...

I had a big reply in here, but it was lost when posting process decided to refresh this page.  I should have learned from these forums to save off big...

Have you tried to force it to use the index that is being used on your old server?  Check BOL for Index Hints.

I don't recommend using this all the time,...

Out of curiosity, what is the final goal here?

Is simply never selecting the non-numeric results the complete solution or do you need to do something with those records?

Regarding SQL 7/2000 (the forum we are in), I went through this dilema about 4 years ago.  While there is a column in the system tables that would make you...

I may be wrong but I don't think this is possible...

If it is possible, it certainly isn't recommended.  I would highly recommend that you look at your options of solving...