Yeah -- Have to do this thing all the time here.

Basically, like someone said above, just create a role.

Add your NT group ("AppDev" or whatever) to that role.  Then grant perms...

-- This is OK (What I Expect) -- Result: 1234.5678

DECLARE @F1 FLOAT

SELECT  @F1 = 1234.5678

SELECT CONVERT(DECIMAL(10, 4), @F1) 

-- This is OK (What I Expect) -- Result: 1235

DECLARE @F2 FLOAT

SELECT ...

Another approch is to just use a "delta time" between the test date and a predefined date (e.g., '1/1/2000') [in whatever units you want] and sort on the difference value.

For example, if "seconds"...