I started to do an update query like:
update comprank set ranking = '1 out of 1' where measureid = '234' and prodabbrev = 'hmo' and rank = 1 and market = 'ca;
but then I realized that is not going to work based on the raw data I have. Here is an example of the data and I also have 3924 total rows and 36 different measureids, 2 different prodabbrev, and 14 different markets. Here is the data like it is in the table, just a snippet. Well it does not paste right so going to attach the excel
update comprank set ranking = '1 out of 1' where measureid = '234' and prodabbrev = 'hmo' and rank = 1 and market = 'ca;
but then I realized that is not going to work based on the raw data I have. Here is an example of the data and I also have 3924 total rows and 36 different measureids, 2 different prodabbrev, and 14 different markets. Here is the data like it is in the table, just a snippet. Well it does not paste right so going to attach the excel