Glad you found it as useful as I did!

If you have any specific questions let us know and we'll try to find an answer 😉

Since the multi valued column is char(10), there can be a maximum of three values (btw: I'd rather use a char(9) length...).

Instead of calling the function I'd probably do it...

Unfortunately, I don't have an answer for you.

But the Service Broker subject in general is not really one of the top issues discussed in this forum (I don't know why).

Maybe...

... and you didn't even use a CTE ...

Nabha's going to like it... 😀

You're very welcome!

And thank you for posting back. It's always good to get some feedback from the OP (= Original Poster = the person that opened a thread).

It shows the...

I can't really do anything about it: as soon as I think a subquery is required...

First of all you need to make sure to know what that value actually represents:

It could be either 10000 or 10.

Based on that you'd have to replace the comma with...

Did you notice that you've got two answers with sample code after that short time?

The reason is simple: You provided ready to use sample data! Well done! 🙂

Having two almost...

I would use a CTE to join the two tables and use the FOR XML clause to get the results.

;WITH cte AS

(

SELECT RouteCd,rd.CoutCd,CoutDesc,SEQUENCE

FROM @tRouteD rd

INNER...

I would use the UNION operator (or even UNION ALL if possible) inside a CTE to get all values except AssetTypeName and join the CTE to the AssetType table.

I would...

@ malleswarareddy_m:

Seems like your question is similar to your other thread : So, please don't cross post.

So, which solution did you try with your data and where did you get stuck?

Please provide table definition, sample data, expected result and what you've tried so far as described...

The description provided so far is not as clear as it would be required to really help you...

What do you mean by "need to bring in data from a report"?...

If you can't post the real data that's causing the problem you'd need to come up with some modified sample data that will show the same effect.

We need to be...

did you try to search for a solution already?

If you type "find duplicate rows" in the search box (upper right side of the form) you'll find numerous solutions covering the...