Ok, the last one was answered very well. So now.....I have a table with 3 columns, Rdate_, service, and paid (date, text, and Currency). The services may be sold at different amounts on different dates. I want to have a view that will show me, for each service, the LAST price paid, the MAX paid, the LEAST paid, and the MOST COMMON price paid. 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/
