you can try this code
CREATE TABLE [dbo].[Products](
[productid] [int] NOT NULL,
[Name] [NVARCHAR](50) NULL
)
--product Meta
CREATE TABLE [dbo].[ProductMeta](
[Id] [int] NOT NULL,
[ProductId] [int] NULL,
[MetaKey] [NVARCHAR](50) NULL,
[MetaValue] [float] NULL
)
DECLARE @strsql NVARCHAR(4000),@substr AS NVARCHAR(2000)
DECLARE @myId INT ,@mypathch NVARCHAR(256)
SET @substr=''
DECLARE @d cursor
SET @d=cursor Fast_forward for
SELECT metakey AS mypathch FROM ProductMeta GROUP BY metakey ORDER BY metakey
OPEN @d
FETCH FROM @d INTO @mypathch
WHILE(@@fetch_status =0)
BEGIN
IF @substr !='' SET @substr=@substr+','
SET @substr= @substr+'sum(CASE WHEN isnull([m].MetaKey,'''')='''+ @mypathch+''''
SET @substr= @substr +' THEN isnull([m].MetaValue,0) else 0 END ) AS '''+ @mypathch+''''
FETCH FROM @d INTO @mypathch
END
CLOSE @d
DEALLOCATE @d
SET @strsql= 'SELECT [p].ProductID, [p].Name,' + @substr + ' FROM Products [p]
inner JOIN ProductMeta [m]
ON [p].ProductId = [m].ProductId
GROUP BY [p].ProductID, [p].Name
order by [p].ProductID'
EXEC sp_executesql @strsql
