A possible solution would be like this. I'm worried about performance though. Couldn't you correct the data in the first place?

CREATE TABLE #Table1( patid varchar(10))

CREATE TABLE #Table2( patid varchar(10))

INSERT INTO...

Please post your query and the problem you had so we can help you. 😉

People usually use STUFF in the code you're using to eliminate the first comma. Since you're not eliminating any character, there's no need to use it.

Be sure to understand...

Great! If you still have questions, come back to ask.;-)

You had a good idea, but you missed the creation of the comma separated values. To learn how to do it you can read the following article. Creating a comma-separated...

Actually, statistics refer to the tables and are independent from the Stored Procedure.

If you post the actual execution plan, you could get more help. Actually, I would recommend you to...

That's because you have the SomeID column that will help you with the group by. That's why I needed a Row_Number() to simulate the SomeID column.

There's a better way, you need to check for Dynamic SQL. Check the article Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url] and come back if you need...

Please check the following article and come back if you need help. 😉

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

Why are you using STUFF anyway?

SSMS won't show all the characters in a varchar(MAX), you need to export them to some client that will show them (or check this article...

If I understand correctly, your original Strings were

Otherwise, I'm not sure that you're getting those results.

However, given the information you supplied, this code would do the trick. It might...

Shouldn't it be ok if the instances are on different servers?

I'm sure it's a different problem (I might be wrong:-P).

The problem is that you don't have an ORDER BY clause. Without it, SQL Server can't guarantee an order of the returned rows.

Eugene,

I found this reference googling dbcc traceon(610)

http://sqlserverplanet.com/data-warehouse/sql-server-2008-minimally-logged-inserts

Again, I'm not saying is a good choice, simply an advice I've got.

Welcome to this forum,

I really hope that we can help you, but there's something that I can't understand. You say: "The flag indicator will tag with 'Y' if 1...