I'm sure... I had posted the same solution for Erik little a few weeks prior to that... also I usually test the solutions before posting 'em so it's unlikely that...

Simple solution > do it application side.

Other solution. Prerun the query like this :

Select case when sum(dtName.Col1) = 0 then 'Col1' else null as Col1,

case when sum(dtName.Col2)...

1 - That was Yesterday

2 - The code is correct and dcpeterson posted the exact same solution 5 minutes later.

3 - So I hear you lost a bet while I...

Not enough caffeine yet .

http://www.sqlservercentral.com

What post?

Knowing your background I'd just say, stay as far away as possible for now... You have way too much to learn before going into administration.

What did you try?

Does this work?

Select object_name(id) from dbo.SysComments where text like '%[Database].[dbo].[tblSpecificTable]%'

I know I've already done that somewhere... What have you tried?

Did you try to place the avg on the footer of the grouping and checking that the avg is right/wrong?

There's no lesson to give... think fast and type faster .

Doesn't access have an average (avg) function?

It's more clear now. I think that the simplest way to apporach this problem would be to have the date of the data inserted in the table. Then...

It's a nice article and it's true that if you can do the work just once, DO IT JUST ONCE. I'm working with a system here where the same...

Not ATM.

Create view;Select null

Can you post the exact code you are actually using?