<div>
Why would you want to do that? 
 
The table you have is properly structured as far as I can see.
</div>

Why would you want to do that?

The table you have is properly structured as far as I can see.

<div>
&gt;&gt;The table you have is properly structured as far as I can see. 
 
I typed each column, I want generate dynamic, I need add count under each name later, 
 
result like this 
 
 
ProgramId &nbsp;[ Mary &nbsp;Lee] &nbsp; [John &nbsp; Stall] [Marshall Young] 
 
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5 
 
 
I have hundred programs.
</div>

>>The table you have is properly structured as far as I can see.

I typed each column, I want generate dynamic, I need add count under each name later,

result like this


ProgramId  [ Mary  Lee]   [John   Stall] [Marshall Young]

1                      2                          3          2
2                      4                          5          5


I have hundred programs.

<div>
<div class="content wysiwyg-content">
Hi Expert, 
 
I have student table, 
 
Id Name 
 
1 Mary &nbsp;Lee 
2 John &nbsp; Stall 
3 Marshall Young 
 
 
 
How I can write a query to create a table use each record in Name as column names? 
Table structure like this. 
 
Id &nbsp; [ Mary &nbsp;Lee] &nbsp; [John &nbsp; Stall] [Marshall Young] 
 
&nbsp;because I have about 100 record in table, I need to create columns dynamic. 
 
Thanks in advance. 
 
 
 
 
 
 

</div>
</div>

Hi Expert,

I have student table,

Id Name 

1 Mary  Lee
2 John   Stall
3 Marshall Young



How I can write a query to create a table use each record in Name as column names? 
Table structure like this.

Id   [ Mary  Lee]   [John   Stall] [Marshall Young]

 because I have about 100 record in table, I need to create columns dynamic.

Thanks in advance.








sql create table statement

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.