<div class="WordSection1"><p class="MsoNormal">This is probably very simple but I am drawing a blank. Do I need to
createa cursor to iterate through a table to grab the top 2 magazines per category? Here is my table and some data .
Theresults I need are at the bottom. Any help would be greatly appreciated:<p class="MsoNormal"> <p
class="MsoNormal">CREATETABLE magazinecategory<p class="MsoNormal">(<p class="MsoNormal"> magazinecategoryid smallint
NOTNULL ,<p class="MsoNormal"> magazineid smallint,<p class="MsoNormal"> categoryid smallint<p class="MsoNormal">);<p
class="MsoNormal"> <pclass="MsoNormal">INSERT INTO magazinecategory(<p class="MsoNormal">
magazinecategoryid,magazineid, categoryid)<p class="MsoNormal"> VALUES (1, 2, 3);<p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal">INSERT INTO magazinecategory(<p class="MsoNormal">
magazinecategoryid,magazineid, categoryid)<p class="MsoNormal"> VALUES (2, 8, 3);<p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal">INSERT INTO magazinecategory(<p class="MsoNormal">
magazinecategoryid,magazineid, categoryid)<p class="MsoNormal"> VALUES (3 9, 3);<p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal">INSERT INTO magazinecategory(<p class="MsoNormal">
magazinecategoryid,magazineid, categoryid)<p class="MsoNormal"> VALUES (4, 10, 4);<p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal"> <p class="MsoNormal">INSERT INTO magazinecategory(<p
class="MsoNormal"> magazinecategoryid, magazineid, categoryid)<p class="MsoNormal"> VALUES (5, 11, 4);<p
class="MsoNormal"> <pclass="MsoNormal">INSERT INTO magazinecategory(<p class="MsoNormal">
magazinecategoryid,magazineid, categoryid)<p class="MsoNormal"> VALUES (6, 12,4);<p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal"> <p class="MsoNormal">The results I want are<p class="MsoNormal">CategoryID
MagazineID<pclass="MsoNormal">3 2<p class="MsoNormal">3 8<p class="MsoNormal">4 10<p class="MsoNormal">4 11<p
class="MsoNormal"> <pclass="MsoNormal"> <p class="MsoNormal"> <div id="content"><p class="MsoNormal"><b><span
style="font-size:11.5pt;font-family:"Arial","sans-serif";color:black">PamOzer</span></b></div></div>