是否可以让 SQL Server 转换一组结果中的条目列

Question

我有以下设置...

Table: properties
p_id [pk]
p_propname
o_id_owners [fk]

Table: owners
o_id [pk]
o_extcode
o_fname
o_lname

Table: selectedfeatures
s_id [pk]
d_id_features [fk]
p_id_properties [fk]

Table: features
d_id [pk]
d_code
d_featurename
g_id_featuregroup [fk]

Table: featuregroup
g_id [pk]
g_featuregroupname

---

理想情况下，我希望它输出

<header> Owner name | Owner Extcode | Prop name | [GROUP NAMES (featuregroup)] 
<row> Owner name | Owner Extcode | Prop name | ^feature code | ^feature code | 

我正在努力解决的组名称位；这些表是链接的，我可以这样显示记录：

<header> Owner name | Owner Extcode | Prop name | Feature Name
<row> Owner name | Owner Extcode | Prop name | Feature Name
<row> Owner name | Owner Extcode | Prop name | Feature Name

Answer 1

你见过这个吗？ 将行转换为列的五种方法