Thanks pg53. I was using rand incorrectly. If anyone's interested, converting/casting the date to a float yields something that seems to have microsecond precision. Have a look at "select convert(float,getdate())". Not exactly sure what...