How do Return a unique number from a datetime field in sql 2008
I am pulling my hair out. How do i return an integer that is unique based on date AND time from a date time field. The value currently in the datetime field which is called datetimsubmitted is '2010/09/03 10:18:05 AM'
It is easy to return an integer from the date only but each record needs to be uniquely identified by an integer based on date and time to the second