Check apex sql doc. It creates a chm file (or html version) and it does quite a good job at it.

Anyways.. how about decimal (16, 4) > 8 for 8 .

Actually what size is actually needed for that task????

I'd defnitly go with QA...

That'll never change .

Check out my version of Noelds' code... might run a little faster and it is easier to understand.

Yup, but in that case it was a lot less trouble...

SELECT Product, 1.0*SUM(SaleQty)/datediff(m,Min(SaleDate), Max(SaleDate))AvgSalesPerMonth

FROM

orderdetail

GROUP BY Product

Will be simpler correct

Damn are we having a bad day or what??????

send the execution plan(S) again please, and identity the slowest clearly.

I think I'll stay oldschool on this one for a while... untill I really need to store only the time... maybe the day will come

See Noeld's solution :

SELECT Product, SUM(SaleQty) / NumberOfMonths AvgSales

FROM

dbo.orderdetail

GROUP BY Product

I'd probabely use DateDiff(M, getDate(), 'static date when the system was brough online)'

I wrote a software to do search in my code (vb and sql). I found out it was less trouble to send the code in chunks of 4000 characters...

Date as foreign key??? in what scenario does that fall in?

Maybe... but it won't be 8 bytes each, but you'll still have to put up 2 search conditions when only one is enough.

There's a reason you didn't find anything... it's because you shouldn't do it. Might I suggest you create a dll and all it both from the asp page and...

Please, for the love of God, do it!!!!!

(sorry getting sick of seeing this field split).

Come on, that's over 2 weeks ago on a thread I didn't participate in!!! How am I supposed to remember that??