I have a table with 3 columns, Rdate_, service, and paid (date, text, and Currency). I want to have a view that will show me, for each service, the LAST price paid, the MAX paid, the LEAST paid, and if possible, the MOST COMMON price paid. (The services may be sold at different amounts on different dates.) I can easily make a new table and feed it with data generated by a declare cursor routine, but I would bet a SQL wizard could make a view that would do the same!!
Mike Sinclair ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
