select question_id, question_name, question_value
from question_data d
inner join question_dictionary i
on d.question_id = i.question_id
where master_id = '2111'
Given this, how do I get it into a format where all the records are on the same row spreadsheet style and the key identifier like Number_of_Bolts is a cell header with 11 as the value underneath it? I want this be a view in SQL Server.