Thank You for all the help.

I agree with everything said. Unfortunately I am working within a system that i do not have control of changing.

The reason for the post was to find out more...

Here is the table I am using.

GO

/****** Object: Table [dbo].[tbl_Bucket] Script Date: 28/01/2015 22:34:07 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[tbl_Bucket](

[BucketID] [int] IDENTITY(1,1) NOT...

I understand what you are saying. Do you feel the same way when it is more exact, such as millisecond (2000-06-11 23:59:59.990)?

Basically I want to make it so that...