Dynamic Pivot Columns in SQL Server

I have a table named Property with following columns in SQL Server:

Id    Name

there are some property in this table that certain object in other table should give value to it.

  • Sample SQL Data
  • Too Difference on Times for Querys to SQL Server from Python
  • ASP.Net and SQL
  • How to use IP for location in Power BI?
  • Does MS SQL Server's “between” include the range boundaries?
  • How do I swap column values in sql server 2008?
  • Id    Object_Id    Property_Id    Value
    

    I want to make a pivot table like below that has one column for each property I’ve declared in 1’st table:

    Object_Id    Property1    Property2    Property3    ...
    

    I want to know how can I get columns of pivot dynamically from table. Because the rows in 1’st table will change.

  • TSQL Pivot without aggregate function
  • Pivot Query - Missing records
  • Show NULL value as pivoted column in SQL Server
  • SQL Server 2008, pivot with no aggregate fuction
  • Pivot Table SQL server 2008
  • Problem in dynamic pivoting + sql server 2005
  • One Solution collect form web for “Dynamic Pivot Columns in SQL Server”

    Something like this:

    DECLARE @cols AS NVARCHAR(MAX);
    DECLARE @query AS NVARCHAR(MAX);
    
    select @cols = STUFF((SELECT distinct ',' +
                            QUOTENAME(Name)
                          FROM property
                          FOR XML PATH(''), TYPE
                         ).value('.', 'NVARCHAR(MAX)') 
                            , 1, 1, '');
    
    SELECT @query =
    
    'SELECT *
    FROM
    (
      SELECT
        o.object_id,
        p.Name,
        o.value
      FROM propertyObjects AS o
      INNER JOIN property AS p ON o.Property_Id = p.Id
    ) AS t
    PIVOT 
    (
      MAX(value) 
      FOR Name IN( ' + @cols + ' )' +
    ' ) AS p ; ';
    
     execute(@query);
    

    SQL Fiddle Demo.

    This will give you something like this:

    | OBJECT_ID | PROPERTY1 | PROPERTY2 | PROPERTY3 | PROPERTY4 |
    -------------------------------------------------------------
    |         1 |        ee |        fd |       fdf |      ewre |
    |         2 |       dsd |       sss |      dfew |       dff |
    
    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.