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?

I know how 612.945 should be rounded by BR.

But it's not.

Can you get right result from your BR function for value 612.945?

Is your implementation valid?

I guess this topic is...