LISTING 1: Stored Procedure with Subqueries

SELECT 'MattressPrice' = Price, 'MattressMsrp' = Msrp, RailIDN, 
	'RailPrice' = (select Price from Items where IDN = 
		(select RailIDN from Items where IDN = @IDN)),
	'RailMsrp' =  (select Msrp from Items where IDN = 
		(select RailIDN from Items where IDN = @IDN)),
BoxspringIDN,
	'BoxspringPrice' = (select Price from Items where IDN = 
		(select BoxspringIDN from Items where IDN = @IDN)),
	'BoxspringMsrp' =  (select Msrp from Items where IDN = 
		(select BoxspringIDN from Items where IDN = @IDN)),
'Name' = ItemName
from Items where IDN = @IDN