How to identify primary key in a table seperated by comma.

[#1]

Dear Friends

I have two input table

Table 1:

Here Supplier ID is numeric field where mutiple supplier linked with the same contract are enter using comma.

Contract ID	Supplier ID	Project Status
123	2	Green
145	1,4,6,7	Yellow
167	3,8,9	Red

Table 2:

Here for every supplier ID the respective article & spend is mentioned.

Supplier ID	Article	Spend
1	1234	100
1	1344	100
1	1454	100
2	1564	100
2	1674	100
3	1784	100
3	1894	100
4	2004	100
5	2114	100
6	2224	100
6	2334	100
7	2444	100
7	2554	100
8	2664	100
9	2774	100
9	2884	100

I want to

• count no of article as per contract id ( so it should count the artcle number for all supplier seperated by comma)
• Sum Spend as per contract id

I am not able to connect the two table as the data in table 1 is seprated by comma & hence not acting as a primary key.

Please help me in case if there is a way around to deal with such issues.

Many Thanks

Best Regards

Rahul

[sujeetsingh]

hi,

just in place of INLINE CODE you can take a table from server as

Table1:

load

sql select*********

from dbo.Order;

Ok

And if not cleare then give a sample QVW.