title: Create unique ID based on grouped UserId
body: <p>trying to write some SQL that does the following.</p>
  
  <p>If I have a user id field, 12345, and there are 10 records for that user, I want to make a field that goes 1234xxxx
  where xxxx refers to order of those records, based on a date field, 1 - 10</p>
  
  <p>so 12340001, 12340002, 12340003 etc, up to 12340010</p>
  
  <p>Thoughts?</p>