You've actually brought zero proof as to why the concept is wrong.

"You just did not want to listen."

The irony, it burns.

"Your argument was - it works for actual numbers, and...

DECLARE

 @enumerator decimal(23,15)

 ,@denominator decimal(23,15)

SELECT

 @enumerator = 2

 ,@denominator = 3

SELECT

 dbo.fn_BRound(@enumerator/@denominator, 100)

 ,Round(@enumerator/@denominator,2)

As I stated earlier, it ends in a 7, just as it should.

Just like you did with the immediate IF, you wrap the Sum around it.

SELECT

Sum(case Present

when 'P'

then 1

else 0

end) as TotalPresent from Attendance

If that really is the extent of your...

That's not a problem with banker's rounding, but with the implementation of it that you are using. Even the OP which launched this thread has a definition that meets the...

For any representation of 2/3 you'd like to use, Banker's rounding will return the same results as Round().

You can store them together or separately depending on your needs, but what we're saying is that whether together or separate, use datetime columns to do the storing. From the...

It seems like the easiest way would be to create a G: drive on the server temporarily that maps to the F: drive (or create an actual G: volume and...

I'm with Sergiy in that I wouldn't recommend actually storing the time in this manner (displaying it, on the other hand, is peachy). It makes date arithmetic easier, but also acts...

Sounds like homework.

Post what you have coded so far to generate the dataset, and we can help you from there.

Banker's rounding rounds 2/3 in exactly the same manner as traditional rounding, no matter how many decimal places you'd like to extend .666... Is this another silly "midnight event" sidetrack which...

You can put a chart into the detail section of a table control, and achieve the same basic functionality as a sparkline. There are some examples of this here,...

@echo off

for /f %%v in ('dir /a-d /od /b *.*') do set newest=%%v

copy /Y %newest% \DestPath

This should get you started. Change \DestPath to whatever destination you want. This works by...

I'm not trying to be nosy, but I still don't know the answers to the questions I asked. You say they are huge, but if you are planning on just...

This should help get you started down the path you want, but are you aware of the fact that you can include inline charts in reports already?

The lookup tables should help with both size and with performance, in most cases, but indexing can be important there, especially with very large lookup tables. Using int lookups also allows a...