title: Update table based on last date of previous month
body: <p>Please would you advise how I could create a column which showed a timestamp/date for each row indicating the last day of the previous month. For example:</p>
  
  <pre><code>Name    Surname     DOB        Timestamp
  John    Smith      1970/04/20  2015/02/28
  Cindy   Smith      1975/03/20  2015/02/28
  </code></pre>
  
  <p>Now this could be for 5000 people and I've just given 2 rows to show you what I mean.</p>
  
  <pre><code>CREATE table employees (Name NVARCHAR(30),Surname NVARCHAR (30),DOB DATETIME,Timestamp DATETIME)
  </code></pre>
  
  <p>To tackle the problem of the dates not showing hours,minutes, seconds, I am using </p>
  
  <pre><code>CONVERT(CHAR(10),Timestamp,113)
  </code></pre>
  
  <p><strong>Do you use a While loop or something to create a column which shows the same timestamp for each row?</strong></p>
  
  <p>Thanks.</p>