[SQL] Aggregate like AVG() with Money Data Type

2004-11-09 Thread andre.toscano
Hello Friends How can I use the aggregate AVG() with a column MONEY? Thanks in Advance André (Brazilian User) __ Acabe com aquelas janelinhas que pulam na sua tela. AntiPop-up UOL - É grátis! http://antipopup.uol.com.br/

Re: [SQL] extra info - curious delay on view/where

2004-10-28 Thread andre.toscano
Hi Folks, It´s just for curiosity I ask: Could an INDEX speed up that SELECT? Thanks in advance, and sorry for my newbies questions. André (Brazilian User) > On Thursday 28 October 2004 11:16 am, Gary Stainburn wrote: > > Hi folks. > > > > I have the following view: > > > > CREATE VIEW "stock_