Duplicate post due to errors in the forum software

• This reply was modified 9 months, 1 week ago by  R.P.Rozema.

As I see it, this is not a problem related to the stuff() function at all. I think you're missing a condition to limit the rows returned by the sub...

Thank you all for your valuable responses. As I think can easily be seen from my opening post I am a proponent of always using the update-alias syntax when a...

@nahid 92520:

Thank you so much. After a lot of searching, I located your script which shades real insight into how to approach this problem.

My case is little reverse though....

Using the outer apply is causing this. Replacing it by a cross apply avoids the problem. Now I just need to make sure that I won't filter out any rows...

Thanks! That's one for me to take away 🙂

Excellent. Then, while you're still in learning mode ;-), please go on and hone your new tools to perfection using this example:
SELECT STUFF(
    (
  SELECT N','...

Not completely like you requested, but having values for column names makes it hard to retrieve the data for your client software, so i suggest you pick fixed column names...

For this to work, specify on the Connection dialog in SSMS, in the Additional Connection Parameters tab, a key Replication='true', then connect to your server and db. All foreign keys,...

I've run cdc for incremental loading in several projects and I've found that it a) has some bugs,  plus b) it has performance issues with larger datasets. In a MS...

A blog from Adam Machanic in 2009 having the same idea: http://sqlblog.com/blogs/adam_machanic/archive/2009/08/03/uniquely-identifying-xml-nodes-with-dense-rank.aspx

It's not really documentation, but at least more people describe the same functionality.

Deferred updates are nowadays even more hot than they were 12 years back: today not only transactional replication uses the log reader's output, but also CDC uses the same output....

This thread went nowhere, very quickly, with the isnull discussion totally irrellevant to the OP's question. I hope you can still filter out the various options presented, komal145?

And if you would use sub queries, would that be flexible enough for you? I've added an additional column to the example posted earlier to demonstrate what I mean. I've...