Creating Multiple Columns At runtime Based on Row Values in SQL

Asked Sep 27 '19 at 12:18

Active Oct 01 '19 at 11:51

Viewed 198 times

I would like to create multiple Columns at runtime based on values in rows of a single column. The values in this columns won't be fixed either.

I have tried using the CASE expression in SQL without any success.

select ProductID , PartNo, Description, Qty, 
      (case when Supplier = Supplier then Supplier end) as Suppliers 
from tblSuppliers

The supplier column will have multiple suppliers.

I am unable to create tables in this forum so its quite difficult for me to show the results like others who are smarter.

But basically i will have multiple rows with lets say the same product having different suppliers.

How to show those Rows of the same product in one row with multiple Columns created at runtime with the heading of the Columns being Names of the Supplier.

I hope i have explained well.

edited Oct 01 '19 at 11:51

asked Sep 27 '19 at 12:18

Muzamil Sajid

1

What you want is known as pivoting a table. This is sql product specific. Tag your dbms. – Serg Sep 27 '19 at 12:24
@Serg "Tag your dbms" means? – Muzamil Sajid Sep 27 '19 at 12:32
"tag your dbms" = Use the question tags to specify which database management system you're using. – Jim Mack Sep 27 '19 at 13:08
See https://stackoverflow.com/questions/10404348/sql-server-dynamic-pivot-query – Serg Sep 27 '19 at 19:16
1

Possible duplicate of [SQL Server dynamic PIVOT query?](https://stackoverflow.com/questions/10404348/sql-server-dynamic-pivot-query) – StayOnTarget Oct 01 '19 at 11:34
See [here](https://meta.stackexchange.com/questions/81852) for some tips on how to create nice looking tables in your question – Oct 01 '19 at 11:53

Creating Multiple Columns At runtime Based on Row Values in SQL

0 Answers0