Pivot table

[amina89]

Hello, I have a table matter (id_mat, libelle_mat, id_module) to have names of matter on the header I used pivot table select [411] AS '411 ', [412] AS '412', [413] AS '413',.... or 411 ,412.... are id_mat how can I do if I dont know the number of matter? I wanted to display in the header every libelle_mat of a module. (I work with sqlserver2008) Thank you.

[Mycroft Holmes]

Wait for it.... here is an article that might help - Pivot two or more columns in SQL Server 2005[^]

Never underestimate the power of human stupidity RAH

[amina89]

Hi, I think I did not explain my problem,how to display matter of a module in header if I dont know know the number of matter because the user add and delete it. Thanks.

[Mycroft Holmes]

That is precisely what I do in the article, buid a string of column headers from the data and build a pivot query based on that. Read the article!

Never underestimate the power of human stupidity RAH