I claim that concept is crap and therefore there is no perfect implementation.

If thee would be perfect implementation you would post it.

Flooding topic by you with words instead of single...

Firewall.

You may create INSTEAD OF triggers on crucial tables and/or add application validation into your stores procedures:

IF suser_sname() IN (-list of logins-)

AND APP_NAME() 'Your Application Name'

RETURN

Of course the users...

You're right about table variables.

Temp tables behave exactly the same way.

While they are small they are in memory.

Yes, David, I see, you getting frustrated, because you've got nothing to say.

Sorry for you. I warned you.

Now, instead of admitting you're wrong you just making stupid lies:

1) It's your...

Everything is much simpler.

SELECT Datediff(wk, @WeekDay1, @WeekDay2)

will always return number of weekends between 2 weekdays.

Multiply it by 48 and get number of hours.

DELETE T

FROM Table T

INNER JOIN (SELECT TOP 10 PERCENT KeyCol

FROM Table ORDER BY DelteT ASC) T1 ON T.KeyCol = T1.KeyCol

INNER JOIN (SELECT TOP 10 PERCENT KeyCol

FROM Table ORDER BY DelteT...

No need for much of investigation.

Just a bit.

"There are two reasons why a real number might not be exactly representable as a floating-point number. "

One reason would be enough.

Function which...

I'm thrilled to see that "programmer thing" which changes data type of incoming parameter depending on the value supplied.

David? I tried to stop you, but you continue to expose your...

So, which version of BR you suggest to use?

Which one will return consistently right results?

But I need to round 612.945!

Is it impossible task for your BR implementation?

I hope you have BR function running on that computer?

C'mon, set up email filter on your account.

Top by what?

DeltaT?

What if 50% of lines have DeltaT = 1?

What if there are 25 lines? How many to cut off?

I wonder how 2/3 would be stored in THAT computer?

Cutting out a piece of finger?

How precise you must be doing this cutting?