Re: [sqlite] Re: user defined function

2007-10-10 Thread Aviad Harell
Hey Igor, Thanks for your replay. I tried not to use user defined function to do it. This code is working on SqlServer but on SQLite I get misuse of aggregate: (SUM(SALES)). SELECT CUSTOMER, PRODUCT, [RANK] FROM (SELECT CUSTOMER, PRODUCT,

[sqlite] Re: user defined function

2007-10-08 Thread Igor Tandetnik
Aviad Harell <[EMAIL PROTECTED]> wrote: I tried to create user defined function called Rank. which gets partition columns and order by column. this function should create rank according to its parameters. i.e.: select customer, product, sales, Rank(customer, sales) from table should return: