Concatenation in SELECT query applied to a many-to-many relationship in SQL Server 2008
$10-30 USD
Thanh toán khi bàn giao
There are 3 tables:
1. Project
2. Tool
3. LinkProjectTool
I need a query that lists everything in the Project table plus an extra column called ProjectTools. This column should contain a comma delimited string with all the tool names belonging to each project. The elements in this column should be sorted after Tool ID.
The input data is contained in "attachment - [login to view URL]"
This data was created with the queries in "attachment - input - [login to view URL]"
The result should look like in "attachment - [login to view URL]"
Could you, please, help?
Thank you.
ID dự án: #18136214
Về dự án
Được trao cho:
Hi, i am excited to work on this project. i will finish this issue in 1 day. i am web developer and having 2 years of experience. Please give me an opportunity. thanks.
3 freelancer chào giá trung bình$21 cho công việc này
Please message me. Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 8.11 years experience in MS SQL Server and 6.3 years experience in SSRS, SSIS (Import / Export). Please let me know m Thêm