Heh... of course if a "lossy" number was stored to begin with, the function will return that same "lossy" number which is what the requirement was... its a FLOAT, not...

...And, now that we've done all of that... I'll bet the damned thing will import using BCP with one of the "native" datatype identifiers... I'll have to try that out...

All right... here ya go... as I always say (in a "Yogi" Berra fashion), "Once ya figure it out, it's easy"

I haven't tried...

'Zactly where I'm headed...

Oh, hell yes!  Got the spreadsheet doing it right... trying to convert it to an SQL function...

It does use an 11 bit mantisa... got the .15626 example and the even numbers through 10 (thinking thats a hint!) to work...  THIS is a bugger!  It would be...

Well, for sure, SQL Server isn't following the IEEE-754 standard.  If you visit the link David pointed out (nice link, by the way... setup a spreadsheet to do all that),...

Actually, there is an ISNUMERIC function (I think... there was one in 2k... did they get rid of it?)

And, actually, you would never want to use it as an ISALLDIGITS...

Hey, have a Happy Easter.  Hope you and yours are doing fine!

Here's the test code I used John... both tables have a composite clustered index on SomeID and SomeNumber...

CREATE VIEW vBIGTEST AS

SELECT *

  FROM BigTest

UNION ALL

SELECT *

  FROM BigTest2

PRINT REPLICATE('-',78)

SELECT...

Ah!  Sorry and understood... guess that's one of the advantages of partitioned pass through views.

Not sure what the problem with the view is... I just created two small 200k row tables with...

Heh... "Employe" is a "short timer"   Had to leave something for him to troubleshoot

Oh yeah... I like the ROW_Number thing, especially.  Haven't had the pleasure of using it in 2k5 but have done some cool things with it in (yeech) Oracle.

On the time...

Whew!  Thought I had a "senior moment" or something.  Thanks for the feed back.

I used the date comparisons I did because I didn't know if times were involved nor whether...

Uh oh... whose tests failed?  I was pretty sure I tested all 4 scenarios you posted and was pretty sure they came out right.  'Course, it's late and I might...