DECLARE @Spare INT
DECLARE @combinedString NVARCHAR(MAX)
SET @Spare = 1
SET @combinedString = ''
SELECT @combinedString = COALESCE(@combinedString + ', ', '') + Model
FROM SpareModelTable
WHERE Spare = @Spare
SELECT @Spare AS Spare, @combinedString AS Model