How to Update a Rank Function

  • Thread starter Thread starter jeremy
  • Start date Start date
J

jeremy

I used knowledge base article 120608 example number 2 to
create a rank function. I now want to update that rank
function to another table so I could use it to group those
rankings into quartiles, but I am getting the error
message that the operation must be an updatable query. Any
ideas how to easily fix this? I would like to do this
quartile assignment for 75 dates, so any ideas there would
be appreciated too.

If you have a response, maybe you could email me directly--
that would be great. thanks.


My two queries used to generate the ranking are called "PE"

SELECT Moodys.PERMNO, Moodys.Date, Moodys.[P-E]
FROM Moodys
WHERE (((Moodys.Date)=#12/31/1926#))
ORDER BY Moodys.[P-E];

And PERANK:

SELECT DISTINCTROW PE1.PERMNO, PE1.Date, (Select Count(*)
From PE where [p-e]<[pe1].[p-e])+1 AS Ranking
FROM PE AS PE1;
 
Back
Top