0

I have a table with columns ProjectId and InfoFile, where Infofile is a varbinary column. There can be many images for a project, stored in the InfoFile column.

I want to get all the images for a project in columns instead of rows.

A simple select query return results like this:

ProjectA  file1
projectA  file3
projectB  file10
projectB  file22

I want the result like below:

ProjectA  file1  file3
projectB  file10 file22

I need only the single field "Infofile' to be shown in rows. Also if the infofile has null, then I dont want that to shown in column.

Other answers are for multiple fields, but here there is only one field.

Any help is appreciated.

Improve this question
3
Related questions
2204
How to check if a column exists in a SQL Server table
2225
How to return only the Date from a SQL Server DateTime datatype
1801
How can I delete using INNER JOIN with SQL Server?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.