SQL Server——列动态的WHERE子句

I have the following table,

我有下面的表格，

id    idAttribute   valueAttribute    idPiece
1         9              '2048'         10
2        18              'DDR3'         10
3         9              '2048'         11
4        18              'DDR3'         12
id