title: Binning time series data and removing multiples within bin
body: <p>2 columns in Sql Server Mgmt studio out of many are ID and DateTime. There are repetitions of some rows, and some the datetime values have varying frequencies...i.e, for 1 ID there may be 3 repeated datetime values , and then the next two for that ID may be 2 minutes later, then another 2 just 20 seconds later. </p>
  
  <p>I want to grab just one row for each 5 minute bin for each ID, or at least make sure each ID's entries are at a minimum 5 minutes apart. Its around 400 million rows and 17 columns, and unfortunately right now they are all varchar(50). I dont know much about DB management, but do know when I tried to even just change the data type on my local machine DB it gobbled up all my remaining disk space real quick. Any suggestions would be very welcomed. Thanks</p>