Hello,
With data only restore in
unic collumn from database, used pg_dump and pg_restore.
Attention: not erase exist data.
Regards.
Robson
What Solution ?
type number integer / type Date
Ex.
2 /
'20/16/2002'
As to divide one i number int number with
date
Exemplo:
> Select Max(RazaoSocial) As mRazaoSocial, Max(Endereco) As
mEndereco, Max(Bairro) As mBairro, Max(Cidade) As mCidade, Max(CEP) As mCEP,
Max(UF) As mUF, ('(' || Max(DDD) || ') ' || Max(Fone1)) As mFone, Max(Data) As
mData, Sum(Qtde)
What err ?
Order By (Sum(Qtde)/(1+current_date-Max(Data)))
Desc
Regards,
Robson
What err ?
Order By (Sum(Qtde)/(1+current_date-Max(Data)))
Desc
Regards,
Robson
Ok, Nick.Masaru,Joel.
Very Thanks! Nick.
It helped sufficiently. :-)
Brasil vai ganhar a Copa do Mundo!
Robson Martins
>From Brazil
- Original Message -
From: "Nick Fankhauser" <[EMAIL PROTECTED]>
To: "Robson Martins" <[EMAIL PROTECTED]>;
<[E
What err ???
SELECT RazaoSocial + ' - ' + Iif(Bairro Is
Null,'',Bairro + ' ') + CGCCli As Coluna FROM Clientes WHERE RazaoSocial Like
'%A%'
