4th or 5th time already in the last 2-3 months... This one comes up all the time.

I was just demonstrating with a sample dataset that AVG and sum/count() handle nulls differently.  Now to think of it I would assume that the avg would be too low and...

Can you show us the some sample data and the required output from the update query... I'm sure there's a way to avoid the spool altogether.

That's what I thaught.  Thanx for the quick fix .

What are you not understanding?

Do you see something wrong with the results of the 2 averages?

Well with a quick scan I can spot a LOT of table scans which is really not a good thing (most of the time).

I think I'll suggest you search this...

Still not quite.  You can have up to a few MBs of data for a single object.  That's why I coded this client side in VBA where I have no...

Can you edit your post so that it's more readable... I'm not sure you'll get much attention from anyone with that question.

You can't use the aliased name withing the same query where it was produced (unless in the order by clause).  You either have to reuse the calculation in the next...

--I don't know if you are experiencing that particular problem but it's always worth mentioning it

SELECT 

   AVG(dtDemo.N) AS Avg1

 , COUNT(*) AS Count1

 , SUM(dtDemo.N) AS Sum1

 , SUM(dtDemo.N) /COUNT(*) AS AVG2

FROM...

That should do it the query you need is the last query of the batch... all the rest is setup tables and feed sample data :

USE SSC

GO

IF