SQL Server: Link two tables and get the rows of second table as columns in the result
16940
Efficiently convert rows to columns in sql server
122500
SQL Server Rows to Columns Dynamically
18626
How does SQL Server order results when joins are used?
110029
How to Pivot Multiple Columns in SQL Server
21815
How to do INSERT into a table records extracted from another table
10831
Join table depending on value of column in main table
11591
Manipulate results to display rows as columns
41542
Combine Two SQL queries in one statement
27240
How to mix pairs of rows without JOIN (in a temporary table)?
65917
Combine multiple results in a subquery into a single comma-separated value
57347
Pivot using SQL Server 2000
149043
Pivot in SQL 2008 R2
156303
Performing Inner Join for Multiple Columns in the Same Table
74707
SQL Server: Is it possible to insert into two tables at the same time?
157366
Transpose some columns to rows using pivot with SQL
108393
Update a table using JOIN in SQL Server?
131790
SQL Server update primary key that's also a foreign key in two tables