title: A SQL Server query that increases the value of everyone's pension fund by one month's worth of contributions
body: <p>I have a SQL query issue which I'm struggling with, I am quite new to it.</p>
  
  <p>Basically I have an pension fund and every month Employees will contribute 5% of their wage to it per month.</p>
  
  <p>As I'm in learning I'm finding it quite difficult to figure out what the best type of query (what I mean by the is <code>INSERT</code> etc) would be and also what sort of information you guys would want from me to assist? Also using SQL Server Management Studio </p>
  
  <p>Thanks!</p>
  
  <pre><code>INSERT INTO CompanyEmployees (FirstName, LastName, Age, Salary, PositionID, PensionID) 
  VALUES ('John', 'Doe', 33, 30.000, 
             (SELECT TOP 1 ID 
              FROM JobPosition 
              WHERE Title = 'IT Support'),
             (SELECT ID 
              FROM PensionFunds 
              WHERE Amount = 250.00));
  
  INSERT INTO PensionFunds (Amount, PensionProvider) 
  VALUES ('250.00', 3)
  </code></pre>
  
  <p>So basically, every month I need "John Doe" to contribute 5% of his 30.000 into his PensionFund.</p>
  
  <p>Hopefully this is what you guys were after. Apologies if the SQL isn't up to scratch.</p>