sqlsean (6/20/2013)

---

sorry mark let me correct myself your query works jus fine and yes indeed it is a remarkable job for the information that I have provided. since you have...

err...huh???

nicklibee (6/20/2013)

---

Following is the relatioship

Table A is related to Table B BY ENTERPRISE_MAIN_CODE AND ENTERPRISE_SUB_CODE

Table C is related to Table B by ID_NO

Table B is...

sqlsean (6/20/2013)

---

thank you for your effort but I get an error when I run the query

Msg 245, Level 16, State 1, Line 1

Conversion failed when converting the nvarchar value '...

meltingchain (6/20/2013)

---

Kingston Dhasian (6/20/2013)

Great job posting the sample data and the structure of the table:-)

Can you also provide the expected results based on your sample data

That will help us to...

Take a look at this article.

http://www.sqlservercentral.com/articles/comma+separated+list/71700/%5B/url%5D

No it is not even close to clear. We are going to to break this apart into pieces. Let's start with the "first part".

Here...

So...

LOL

Well I don't understand the rules because it is very vague. I also don't...

That would probably help. It is pretty tough for me to say for certainty though.

Also, I should be ashamed of myself for not putting an ORDER BY clause on my query. It is imperative to use an order by when the order of the...

Don't use the TEXT datatype. It is deprecated and the performance is horrible. It is also incredibly painful to work with. The replacement is (n)varchar(max). It would be FAR better...

Is there a question here?

A rather strange request and a bit limited I suspect but this should do it. Notice how I posted readily consumable ddl and data? This is something you should do...