I've got a table: +-------------------+-----------+----------+-----------+--------------+ | FieldName | ValueChar | ValueNum | ValueBool | SubmissionID | +-------------------+-----------+----------+-----------+--------------+ | Color | Red | NULL | NULL | 1 | | CrayonNumber | NULL | 38 | NULL | 1 | | IsToxic | NULL | NULL | TRUE | 1 | | CrayonCreatorName | Bob | NULL | NULL | 1 | | Color | Blue | NULL | NULL | 2 | | CrayonNumber | NULL | 17 | NULL | 2 | | IsToxic | NULL | NULL | FALSE | 2 | +-------------------+-----------+----------+-----------+--------------+ I'd like to create a view that when queried would return: +-------+--------------+---------+-------------------+ | Color | CrayonNumber | IsToxic | CrayonCreatorName | +-------+--------------+---------+-------------------+ | Red | 38 | TRUE | Bob | | Blue | 17 | FALSE | NULL | +-------+--------------+---------+-------------------+ Is this possible without stored procedures? Continue reading...