DECLARE @templates TABLE 
  (TemplateID INT IDENTITY(1, 1), TemplateName VARCHAR(50))
DECLARE @attributes TABLE 
  (AttributeID INT IDENTITY(1, 1), AttributeName VARCHAR(50))
DECLARE @template_attributes TABLE 
  (TemplateID INT, AttributeID INT)
DECLARE @values TABLE
  (ValueID INT IDENTITY(1, 1), TemplateID INT, AttributeID INT, Value VARCHAR(200))

INSERT INTO @templates 
  SELECT 'Restaurant' UNION ALL SELECT 'DBAForHire'

INSERT INTO @attributes
  SELECT 'Name' UNION ALL SELECT 'Adress' UNION ALL
  SELECT 'TakeAway' UNION ALL SELECT 'YearsExperience'

INSERT INTO @template_attributes
  SELECT 1, 1 UNION ALL SELECT 1, 2 UNION ALL SELECT 1, 3 UNION ALL 
  SELECT 2, 1 UNION ALL SELECT 2, 2 UNION ALL SELECT 2, 4

INSERT INTO @values
  SELECT 1, 1, 'Lumbagos TexMex' UNION ALL SELECT 1, 2, 'Mainstreet Oslo' UNION ALL
  SELECT 1, 3, 'Yes' UNION ALL SELECT 2, 1, 'Peso' UNION ALL
  SELECT 2, 2, 'Somewhere IN Sweden' UNION ALL SELECT 2, 4, '10'

SELECT TemplateName, AttributeName, Value
FROM @templates a
  INNER JOIN @template_attributes b
    ON a.TemplateID = b.TemplateID
  INNER JOIN @attributes c
    ON b.AttributeID = c.AttributeID
  INNER JOIN @values d
    ON b.TemplateID = d.TemplateID AND c.AttributeID = d.AttributeID