tag:blogger.com,1999:blog-54536044843817731112024-03-13T18:22:15.625-05:00Data Doing - SQL Server, BI and StuffRandom thoughts and learnings from the world of SQL Server, B I, data and business.Anonymoushttp://www.blogger.com/profile/02484976284138761437noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-5453604484381773111.post-70172453215022842382014-09-09T16:23:00.002-05:002014-09-09T16:23:37.173-05:00Solution to the Matching sets problemThis is in response to my <a href="http://datadoing.blogspot.com/2014/01/looking-for-matching-sets-looking-for.html#" target="_blank">earlier matching sets post.</a><br />
<br />
I actually figured this out not too long after the original post, but then life happened (and the project that needed this was fundamentally re-defined, making the question obsolete).<br />
<br />
So today I was doing some clean-up work and ran into to the code that I was able to use to solve the problem and realized that I never posted it.<br />
<br />
The only real solution I came up with is a fairly brute force solution: Take all of my groups and render them as ordered lists, then take the service codes from each work order and render them into ordered lists as well, and finally see which work order matched up to which group.<br />
<br />
Broken down:<br />
This collapses the group definition.<br />
<span style="font-family: "Courier New",Courier,monospace;">SELECT<br /> WONum<br /> , STUFF((<br /> SELECT<br /> '| ' + dbo.WOs.ItemCode<br /> FROM<br /> dbo.WOs<br /> WHERE<br /> W.WONum = WOs.WONum<br /> AND ItemCode IN (<br /> SELECT DISTINCT<br /> ItemCode<br /> FROM<br /> dbo.QualifierGroups )<br /> ORDER BY<br /> ItemCode<br /> FOR<br /> XML PATH('')<br /> ), 1, 2, '') IGroup</span><br />
<span style="font-family: "Courier New",Courier,monospace;">FROM<br /> dbo.WOs W<br />WHERE<br /> W.ItemCode IN ( SELECT DISTINCT<br /> ItemCode<br /> FROM<br /> dbo.QualifierGroups )</span><br />
<span style="font-family: "Courier New",Courier,monospace;">GROUP BY<br /> WONum</span><br />
<br />
Which results in:<br />
<img alt="" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMUAAADxCAIAAAD0seQcAAANHElEQVR4nO2dv2sbWxbH9T/oP0iR0p1rF95SRUjlxur9BwR3gsWblMt2Qrjd1wnSJoUQuEixEG1hlmAQvIDBDx4PzNM2cXW3OOurk/vLd+6c+XFG308TeyRdndF8fGcy852j0QgAIYwx//9HL9rrHwzwCUgCn4Ak8AlIAp+AJK5Pd5ubxXJlH356+vGPy7897nZ2ycP99q9//6f9dbd7nLx6NR4fbe8f2qo5APfp+7dbp5inpx+XZ6ej0YivGmiCgE+vXk2sQHebG2czrJaL6Wxunk0ajUY3mzt6Gn/hfDblL6Qt2tzm5D7NZ1PnfUej0enZ5e9//GYLbqgM4PpElthPfLVc0Mb48fRknjcPPTqfTe1y+xCpRo++efPGzltd+eQUCZrG9YlvePr5+pdfTl6fkBYP91v62dGO4HMbbdT5bEqG8WF9ZWmTPz39+HBx8Wn96Wg8ptnutz9+p9nlxf1p0KdgkXY17XtRzXa65W+XWWrnu/v+EDget5/abvd48ZcL2qj0md5tbughKxYfiy+kjWqXZPp0eXZKW9fup4JzYWw1COuTs+/m8Pcy3vTJP4EXS+XLq376wyPg08P9dnJ8/rjbWXvsNJPeVL5P5lmFP//7Z6ZPdrl9U8M8Tq+GfaFfJB3hETebO+e97Co7K5JZavCv6zAJ+GQ/xNVywTcMn6gy5ydaeDQef/7ytX2f/CLtWzjv5fx57HaP58cT+FRA+PzTfDZ9++7KfmT0+X5af7J/xPRBO8fXfNrnB8Wr5eJ4cn4+OW7ZJ7/ITJ8wPxUT9uluc/P65MTaY49m7AY2xqyWC34cSjsUboPdkPZQlx/m85MODflkvPMdMZ8c8+zhWrpU/p8PHD8RYZ/4Z0dL6MSB838lOsnEj0v4Q3xicLYr7QTpP3Hr9cfmfOLvRfDjfV4wf5ozV8VKff/+vfP/QYDrLSX4OgICPpUAn2LApxLgUwz4BCTZ+wSACAbzE5ACPgFJ4BOQBD4BSeATkESlT3ebG34l0YR88p/jX0SKPdOJr/gjj36+lBkcPPZ2w0aZTzwPzrcTrz/4HHv1ml+IjI0W84kUmc7m9APP0zmDB9/uEFDm03w2pa2V8Ml/jpMnsQ/FRkvPT/Y5NKY/+OjnK8QHld5U5hOR9sl/jn/TDv+1pk/BO4ISbzdsDsIn5/mOLgU+UYiFUjH+4M4ONMfOwQCfqvnEY1L0KvjEgU+F+zsb6YRPnIPwKX3AVOaTeU6Q+oM7x084Hu87VX3i8XD/TuV8nx7ut7ffvtuf6RDKH/zq+jrxdsNGmU9OYt164Jwv8J/D77/jN8UHR0uff/LH8QcPvt0hoMynGLL1H9QRjyzwKQB8KgY+BYBPxcAnIMneJwBEMJifgBTwCUgCn4Ak8AlIAp+AJPp88ltYG8+nzIh3bCEoRpNPzuUzfg3f1p8f8Y4tBHXQ5BOHLu9bA4L1JyLep2eX2+1tMFTeTv1D5SB8CubH1+uPB5vybg6tPjmb368/HfGeHJ9fX18dbIqyOVT65Dfu5fXnRLzhU0Po88n5ohgiWH8i4g2fGkKZT0GZTPz8UyzifXp2+fXL54NNeTeHMp9inb5t/ZkR79jCFldlmGjyyekkPgrlx/Mj3rGFoA6afEqgvf7BAJ+AJPAJSAKfgCR7nwAQwWB+AlLAJyAJfAKSwCcgCXwCkujzKZgN9+vvZ//xF1MMNLjzKn9hcPBgsr5lNPkUy4YbPf3HEz5xRVbLBf+KdmehP3giWd8ymnziOJFwXn+f+48nRubfv51YGFsX/gSehG6ZAfpE9LP/eGLmOz+eOF+SHlyYXhcDnwrg2XAi7VN/+o8nOnNOjs/X64+0w6KXBxem18V0fWOFMp/8bDgtb82nmv3HEz4djce0a7MZ1ODC9Lr4yfqWUeaTxfngWp6fTGn/8fT85OzF/v2ff/kLE7H3WBi6TbT6ZH4+Vq10/NRh//HM4yca89eHX/2Fzm2DdvA+yGR0+RTMhtOvaZ/60388NrJjA5kaXBhbl1iyvmU0+RTLhhs9/ccrHZnFFvqDJ5L1LaPJpwSy9Td3L97g7/KDTwHgUzHwKQB8KgY+AUn2PgEggsH8BKSAT0AS+AQkgU9AEvgEJNHqE0Ur7a9O/eg/3hUqfaJr+MH8E/qPd4s+n2xqMZ2nM+g/3gX6fJrPpovl6m5zk+8T+o+3hjKfrEYv+oT+452gySeKj9FRTsIn9B/vEE0+rZYLHmF7cX+H/uPto8knJ045YrdNxupH//GW0eQTJzY/of94twzNJ/Qf7xatPjlor38wwCcgCXwCksAnIMneJwBEMJifgBTwCUgCn4Ak8AlIAp+AJIP1SWn/cZ/8smn8i4sPHV7V1uSTbRdODKn/eGzVKpVtl6N/ZhY8T+fA69fYfzy4amVlO7mulhmgT4Su/uPBVataNuUNHQtbRp9PtEfgE4DR3388uGqVyrZGdpvl0uQTxzkuac2nhvqPB1etUtn8UScc1iZafTJV+kX3v/94cNUqlU0Wcjq5PfUgfOp///HMkWNlO6lUopPEqVafnG+9SfvU//7jwVXLL9u/GbWr21M1+eR02Y59H5DG/uOxVcss++rd2+D51fZ3eZp8SiBbP/r7FgOfAsCnYuBTAPhUzN4nAESAT0ASg/0dkAI+AUngE5AEPgFJ4BOQRKVPdBUi3Z+uTn4cFKPMJ+7EarkIfh91/fw4KEaZTzyjwuH118+Pg2I0+bTbPZ4fT4LJaL/+OvlxUIwmn+w3I9B52PTxU518JihGmU9H4zHt7+jQp6G8LyhGmU/cA77bgk89QZNPzvFTvk9V8+OgGE0+Ofu4/PsRqubHQTGafDKh299ouXO+gMcnCvLjoBhlPsXQXv9ggE9AEvgEJNn7BIAIBvMTkAI+AUngE5AEPgFJ4BOQZLA+9bNf9ODR5JPT1GbErpDw+vvcL3rwaPKJ41zW5fX3uV/04NHqkxNB8evvZ7/owaPVJ+fGhLRP/ekXPXhU+uS3bG/Np5r9ogePSp/8u6Zanp9Mab/owaPPp2Cn0UrHTx32ix48+nwKbp60T/3pFz14lPnENx7HOV/gn6PqSb/owaPMpxiy9R/UEY8s8CkAfCoGPgWAT8XAJyDJ3icARDCYn4AU8AlIAp+AJPAJSAKfgCT6fKILZ84VN7/+fubHC85sVWpz/XC/vbj40OG1Z2U+zWdTunRPGzX4/cF9zo/HRraVEImRE2Xb5R1eftbkk9OfLtZPrM/58bRPTginrOzr66sO4zHKfIrlQPz6+5kfr+RT1bJXy8V0NvfDq22iySfzvLVen5zYRr9E2qf+5Mdz9nd2bqtUtjWy28SVMp/4596JTzXz4zkzHz8Iyy+bP3q3uelql6fJJ570bbT/eHP58UpJ4kplk4WcTm4i1eST82fXXL/o5vLjNUeOle0ER/35uzWU+RT7f1Pap/7kxzOP9I/G45vNXX7Z/i2jXd1Eqskn83Pim7vlnC/gf6a9yo8nTOWtGaw3mWVfvXsbPL/a/i5PmU8xZOtvLp85+OQnfAoAn4qBTwHgUzHwCUiy9wkAEQzmJyAFfAKSwCcgCXwCksAnIIk+n/i3nFty6tcVxFaKJp/omihd5pzPpsHrd4MJYitFk0/ONfP5bOrnfQcTxFaKMp9iAaC0TxqD2EpR5lPMg+D+TnUQWymafHKOjUaR72+xqA5iK0WTTw60V6KfY/XrDWIrRbFPweNx/zlKg9hK0erTarlIfx+QUR7EVoomn3jI2tnGtv7BBLGVosmnBNrrHwzwCUgCn4Ak8AlIsvcJABEM5icgBXwCksAnIAl8ApLAJyBJ333KbCPu11+n/zgopr8+5bcRN9L9x0Ex/fUpv424ke4/Dorpr09EZhtxv/46/cdBMZp8SsQs0z5V7e8LioFP8EkS+ASfJNHkU879UlVf6P8K6qDJp+LvA6rafxwU01+f8tuIG+n+46CY/vpUCe31Dwb4BCSBT0AS+AQk2fsEgAgG8xOQAj4BSeATkAQ+AUngE5Ck7z4Fw93+Qr/+OvnxF7+lLnPwqiPTRaGckYMLC75cT7wne399Coa7Y4lvXn/9/Hhiw2QOXnVk2q7T2Zx+SLdNj4XoY4O32ZO9vz4Fw92xxDevv35+POFT5uBX795WHZk/hwYMjrzd3sZC9Gmf2unJ3l+fiGCYJO2T/5yq+fEXt3rm4DV9Co68Xn+MvV0lnxrqyX4QPlXNZ1byKTF4wcjUr5H2KcGRnRmCD5izv2u6Jzt86otPvPMnvUrKJ6fyUZM92eFTX3yy2DRpEz6ZhnuyH4RPVfPjdY6fEqrljEwk2qZ//fI59nb1B6/fk/0gfKqaH6/kU2Lw/JEf7re3377bn+kQKjhy4u0yD/Yb7cneX5+C4e5Y4ts5X+A/p1J+PH2+IGfwqiM7c4CtMFh2LESfkLW1nuz99akSsvUXnGjufOSmB88EPgWAT8XApwDwqRj4BCTZ+wSACMYY/HEDSf4HbHfG+kpLvgAAAAAASUVORK5CYII=" /><br />
The second half does the same thing for the groups:<br />
<span style="font-family: "Courier New",Courier,monospace;">SELECT<br /> G.GroupId<br /> , STUFF((<br /> SELECT<br /> '| ' + ItemCode<br /> FROM<br /> dbo.QualifierGroups<br /> WHERE<br /> GroupId = G.GroupId<br /> ORDER BY<br /> ItemCode<br /> FOR<br /> XML PATH('')<br /> ), 1, 2, '') IGroup<br /> FROM<br /> dbo.QualifierGroups G<br /> GROUP BY<br /> G.GroupId</span><br />
Which then results in:<img alt="" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMUAAACNCAIAAACIUSmmAAAIUElEQVR4nO2dMW/bOBTH9R38DTx0zJY5Q270B8iS7P4EQZcABa4di9uCoGuz5dD5hiCAhxsKnDscOhgw0MGAVwOemok3vAPNUo80RT9KetL/t9xVUWlS+olS6L9eqwoAIYwx//9HL9r7PxjgE5AEPgFJ4BOQBD4BSXrt02q5uLy6/fn6enTPfvZ/hPA+bTfrs8nE/ga4WK6KduL+7ubm7r6+Pc8nr7WWxzJyGJ9Wy4V73Pf73fy3+W6/L9eJcj61P5aR4/u03+9m0yl7Ee/3u+vz2ePjp6qqptPZbr9/ff15e3VJ1z1tMcbQRtuCdeL19eeH+fzr92+z6bSqqsnkbL3Z0j6uAXY6mUzOHh8/neJTJ2MZOb5Pq+XCHk0POj3esbYePD89uCeGPQe3V5f20Nv9jWMA7fPw9Gw/7hSfOhnLyIn59Pz04F6v3uW+3axn59f2INIVv95s4+fAvfXQ/sYxwGvzxPtdJ2MZOcfnJ7vFOwfenvYQp58D21poRhH0qbWxjJzjz0+hc9D/+amTsYwc5vc7ujXUr13vHNSfOey5d/04m0xCzxz1/ekj6PnJ/buJwyDcp/v2xzJyktaf3Adk93KnLbSPe0Dt9ul09vLyxT0HX15e7I/sfMD+fjedzr59/zqff5Bdfyo9lpHT3vq4d4+QpeX18aJjUQ18ygE+hYBPOcCnEL3+Pjgd7f0fDAefABDBYH4CUsAnIAl8ApLAJyAJfAKSwCcgiT6f6Cte+hrO4vW/vo/7LZ67Dsm2BrLR5BN9Nfvx8582w2mx/Wf3cWMLq+WCcgGR1kA2mnwi3Eywxeu/t48bl/O+KmFbA9mMwic3n+T9CD7JMjqfjDH3dzfwqRCj8wnzU1FG4ROen1pjFD656V72VRb4JIUmn9yIN2E98NYL6vu4rx3TSwSR1kA2mnyKoL3/gwE+AUngE5AEPgFJDj4BIILB/ASkgE9AEvgEJIFPQBL4xOCVgwLpwCcG+JSNMp9sGczq1xi41/8T8+MRn7w6nKHGQx83eDT5tN2sbXkxr6Su7b9Ifjzk036/+/32j0hNPWqc6kh7H1fsqPQLTT65bDfrizcX9jx5/T8x/5Ryv7MZvXrj79+/D33c4NHqkxdjivvUNJ951Cd3Tqo3XjkVE8eWr1LpU/0kpftkEvLjEZ/oH/Coqoot3kqNV79W4HQ/bvCo9On+7sarp9vy/GScBzjMTy76fKrLZLp4frIPcHh+ctHkE50bttJ33Kem+fGQT9vN+t3Hz/T/dn6qN/5j+yP0cYNHk0/22cViH2K89QJ3n4z8eMgn99+gclcB6o3Xt4wETT5FwPp4T4BPDPApG/jEAJ+ygU9AkoNPAIhgMD8BKeATkAQ+AUngE5AEPjGUWy8Y/EoEfGKAT9ko84mNbxs9+fGUbwYr53vJpmXTKX3VYZxBk09sfJuw/e95fjzuk+dB027v97vr89nbt3P3yLSMJp9cvFSk1//e5scb+dS026vl4vLqdr3+t8Nbqkqf3AuXiPvUn/x4oyRM025TsLjbRKgyn+rxbSLdJ9Npfjw7SXy02+4LP95fbBNlPllC798Rvc2Pp7RsA5+Nuu3u7L1M1iZafer8/bu8/PiJLYe67f16SHRyy9PkExvfpj/GfepPfjzU8ueP7+y1YV+4SO92/S1k7/i0hiafQvFtoyc/HmrZjca7jz6J3fZWT8yvl1CbaPIpgmz/sT6eDXxigE/ZwCcG+JTNwScARDCYn4AU8AlIAp+AJPAJSAKfGAb/W1g54BMDfMpGpU+UCQnlnxIjuaGNRiiV29tIblH0+bRaLs5n19ezc9anxEiuDc6WSOVS3re3kdyiKPOJzuhff/8Tr8dKRCK5i+UqkgYRSeX2NpJbFGU+PT893NzdH63va45Fch+eniNpNZFUbm8juUXR5JM9zXGfUiK5nk+mQCq3t5HcoqjxKX4rCd3vQpHcvPnJ5Wgqt7eR3KKo8ameI6uc6Bnb/3hwNuP5Kb1x0+NIblHU+OQSmZ8SI7mhjbaR01O5vY3kFmVoPqVHckMbzcmp3J5Hcoui0qc6WB/vCfCJAT5lA58Y4FM28AlIcvAJABEM5icgBXwCksAnIAl8ApLAJwa8H5wNfGKAT9lo8ikU3zb660V7jbvfJ9Y3RuLq9U9sGX0+sQfL9l9pvWgTSNjVN7Jj2W7W8/kH2q3b2MLQfHL3VFQvmt5T8OJ17MbIWOxHdJjU0+dT/Y5g9NeLJgkuLt64t3J2Y2QshJflahlNPrlk1/c1vawX7d4W6fGIEqT1jZGxhIbTJlp98sJoLc9PRrpeNBvsZDfG5yebGm1wKEXR6tPA6kW7w7FdYjdGxtK5TEaXT2x8m/4Y96n/9aLdbtjbHLuRHQvt2blMRpdPofi20V8v2gRWleIbbePukfEe71pGk08RZPuP9fFs4BMDfMoGPjHAp2zgE5Dk4BMAIhjMT0AK+AQkgU9AEvgEJIFPDErXC/qwGAGfGOBTNvp8YkPWXv/L5cfTGy+UTI+MRaRseqjnJq1yujKfQmVMbf9L58dTGo/UHz8xmV60bHr8mCRWTtfkE5unJrz+F80/JTZeIpneQtn0UM8TK6dr8onNUxNxn2TzmYmNl0imt1A2PdTzxMrpmnxi89T0o3SfzGn58fTGSyTTWyibzvY8vXK6Mp9C1XMHMz+Zrsumsz1Pr5yuySc2T00/GtLzU7dl0+s9b1Q5XZNPbJ6afhT3SSo/3qjxEsn0Fsqm13veqHK6Jp9MeMnEWy+oX0ki+fHExosm00MbI40nlk0PDbBR5XRlPoWQ7T/Wx7OBTwzwKRv4xACfsoFPQJKDTwCIYIzBxQ0k+Q8BIMXNP8zW+wAAAABJRU5ErkJggg==" /><br />
<br />
<br />
<br />
<br />
When put all together we get:<br />
<br />
<br />
<span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;">WITH WOGroup<br /> AS (<br /> SELECT<br /> WONum<br /> , STUFF((<br /> SELECT<br /> '| ' + dbo.WOs.ItemCode<br /> FROM<br /> dbo.WOs<br /> WHERE<br /> W.WONum = WOs.WONum<br /> AND ItemCode IN (<br /> SELECT DISTINCT<br /> ItemCode<br /> FROM<br /> dbo.QualifierGroups )<br /> ORDER BY<br /> ItemCode<br /> FOR<br /> XML PATH('')<br /> ), 1, 2, '') IGroup<br /> FROM<br /> dbo.WOs W<br /> WHERE<br /> W.ItemCode IN ( SELECT DISTINCT<br /> ItemCode<br /> FROM<br /> dbo.QualifierGroups )<br /> GROUP BY<br /> WONum<br /> ) ,<br /> <br /> GroupCodes<br /> AS (<br /> SELECT<br /> G.GroupId<br /> , STUFF((<br /> SELECT<br /> '| ' + ItemCode<br /> FROM<br /> dbo.QualifierGroups<br /> WHERE<br /> GroupId = G.GroupId<br /> ORDER BY<br /> ItemCode<br /> FOR<br /> XML PATH('')<br /> ), 1, 2, '') IGroup<br /> FROM<br /> dbo.QualifierGroups G<br /> GROUP BY<br /> G.GroupId<br /> )<br />SELECT<br /> w.WONum<br /> , ISNULL(gp.BonusPts, 0) BonusPts<br /> , g.GroupId<br /> , gp.GroupName<br />FROM<br /> WOGroup W<br />LEFT OUTER JOIN (<br /> GroupCodes G<br /> INNER JOIN dbo.[Group] GP<br /> ON GP.GroupId = G.GroupId<br /> )<br /> ON G.IGroup = W.IGroup</span></span><br />
<br />
<span style="font-size: small;"><span style="font-family: inherit;">So the final result becomes:</span></span><br />
<br />
<br />
<span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: inherit;"></span></span></span></span><br />
<span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: inherit;"></span></span></span></span><br />
<span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: inherit;"><img alt="" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAARkAAADxCAIAAABwElQbAAATnUlEQVR4nO2dP28cRxLF+R34DTZQqEwxA124AUMl2pyfgFCygCDBIaFsQTClMhpO7YAQwMCBAdOB4IDAAg4I0IBhgPBeIkZ9Qd0Vi929s8Ot/lNvr37J6Why573pftMzs93Ve3uO46gJIfz3f3BB189AG4EWr8ezZAtoI9Di9XiWbAFtBFq8Hs+SLaCNQIvX41myBbQRaPF6PEu2sG/k5vrq9Zvjbw8P6X+yL74qcZYuL07lmbq7Xb7c37+6vuE/kL9A/5VfCJ5eXPKvLeaz6CeXF6ez+aKqjZSHh2/Hb16zwslker9aVdLAkPf0iGPOwHB3jE64bJfiLOazrNotstRSdmje95g4S3e3y4MXB8vbO/q/N9dXe3t7UsdiPiOV9J/4vND5YgOL+ezw8PC5PUlpI4WyRKro3w3OKZ+iEMLlxSmfBGWWohO+Wt0f/euo3qWhVJYayw7N+x4TZ0l2PpJ19O7d9NVbkrVa3b99NV3e3kW/RtxcX7GBxXx2cv697Lvsh/6WTy63zcPDt++Ojn75/bfpZEJX9D///otGlf39lxzvARspkU45qMohi2XTD3/48oU08HHXaabPpA/hX5ZZWq3up5PJTz//KodH+q/pHw4Yoc9Jr+jUIp8/n7GLAV8bz7lUIrPEA8v+/svPn8/GZ2md7NrK1/W98HSQpI8d2fGy8lL7T56X+MDklo5BR+W0RMOXPDuyP8lfG5Ol4zevo9NKvxbdeY5pRelfjkvZMYpHD/q5TMWw5rvbJV9oGJml7Bmgn6d/OGBEXqeicz6dTKKet87XunPOfuUoGnknR3S48VlaJ7u28nV9b7W6/3j8iS+Cz+p48uKS7ZCZLMnAHB199+3hgTsHa8p2BXkR4j9ZzGd01JFZ4p/LnjfQJOtakYiel/jUR/qj8XajNpml6HkyPM0S2w+5q2N6wR6TJR7QJpPpH3d/yAu/0ld0Ncy29bPu8dbJvl+toiGrrPJ1fU/CRxzT8aLBQx4usv8kS2ySP5QM/PPvf/iQI8cl/rTTi8uOWeKefXN9RXGKPpAP/dwsBXHPIPPD6ZXdLmrR9A8HjKRngH4SZUnpK7oacuvLz9w6S9FPoiyVVb6u7wUR6ejecmOW5OuT7HNHJkusZjGf0QEoJD9++VE+OKX3wdHzkuzBk8n07OxD9yyx7FLjEh8o25YR2atjdCbHPy9ls2RtXFonu824FJK+JzvSc8el7D15aj/O0s311YuDA/5jOtjh4aHsCpcXpzKa6Xs8/jffaPGfy3Z6ub/fflxK7843ZiarOTrQxiylvTA64sB7PLqgRhfyKEvrfK3Tnz51pL/PV/d13odbISs7zVJZ5ev6XnS5Hz8uZV+2Ze3HWUofMaMzwkdaN+RF/YnOAkukz6dB9suXH5o9L+09fTlLGuSd2ECWsprlGZBXiuxJlzd12T8cMBJ9AnF6cZle+LO+hs85v7eUJzn7Hm8ymf72+y/0FD2+FbLfQ1ZVPtD3+A78w9kZvZ0f2fGivjTq3QMi6PqZxkaibqSkpfiyyovgWbKFZ2kknqVaoOtnPEsj8SzVAl0/A20EWryexyw5jqMk+LhkB2gj0OL1eJZsAW0EWrwez5ItoI1Ai9fjWbIFtBFo8Xo8S7aANgItXo9nyRbQRqDF68HLEs0MjCa8WdMvJ/an3ydGM7vGz8erpKcUXVqhS0mPLEhZojmOtPzYcpZ4DWV4ut6TGfjOvoaRjXpK0TFLjUt6ZEHKEpGd/W5Wf3bRZOMsbdRTiu5ZCiPKGdTDs1SX7GoReVsSrVWpbWTj6hUN3bM0ZpVRPTxLFRnTtNFNV1UjtbuaheeljSWr6uFZqogsnLKOkWvUm+nR0H1cCmLpdHslnqVajOy40QNMPSO1gxRsZGmgIl9tPEvlIYXZghD0iun85L0sjCh/s4aRrJ4aWMiSj0ujkPUACD6DpvTLWg78DZLMkvyFqIvXMJLVU/wowcbzUtUv0IZBytIA6PoZaCPQ4vV4lmwBbQRavB7Pki2gjUCL1+NZsgW0EWjxeh6z5DiOkuDjkh2gjUCL1+NZsgW0EWjxejxLtoA2Ai1ej2fJFtBGoMXr8SzZAtoItHg9niVbQBuBFq8HLEvr6hag6GfS3byJ7YzQnkJyvi9tIpQu4F23r14oUe2+UiuscxdymqsaHAYpSwN1CyD0M3KnvWhe89ZZOjw8lCdkx7KUdRc8S0VotuynBuluc8q1gIv5jErKyD0qdylLWXfBs1SEqG4Bln5Z3yNafrN1lk4vLuX1ZceylHUXPEt60uWAWPqjWjlyf1VNloJYWbh7WQqJu+BZ0pMut8bSX2lcCuJJbCezFLkLniUl2boFQPpDnecluUh7MpmenX3gLEVvwHCzFJ66C7k7lKoGh0HK0kDdAgj9jKzvUeTBT/Y2XrNNvU2+8JTHBc1S5C60NTgMUpYG6hZA6Jfw90tFak3K3sYfLnsbn7G0UxL7+y+/LpfKQnMNshQSd6GhwWGQsjQAun4G2gi0eD2eJVtAG4EWr8ezZAtoI9Di9XiWbAFtBFq8nscsOY6jJPi4ZAdoI9Di9XiWbAFtBFq8Hs+SLaCNQIvX41myBbQRaPF6PEu2gDYCLV6PZ8kW0EagxesByxLPvIo2MEbRT0RTxeTUshpGBg5Xll6tkG7B1GX7Z6QsrVb3H48/0STxxXxWuwvWY2DCcr0sNdjhq2+Wem1hxiBlSRItTcXS71kqi2dpe2QdHwJLv7wnKbLmYuvDlcWzFICyxEuYopt+FP0pjYuTRYcri5HnpXoGhwHLEgNdH08il4KG+kaiw5XFx6WAmCXo+niSxkaiw5XFsxRQsnR3u3x/ck7/hh6Xzk/ec2+OSsHUMDJwuLJ4lgJKlho/stdDFq5oUJxs4HBlMfK85N8vqUDXz0AbgRavx7NkC2gj0OL1eJZsAW0EWrwez5ItoI1Ai9fzmCXHcZQEH5fsAG0EWrwez5ItoI1Ai9fjWbIFtBFo8Xo8S7aANgItXo9nyRbQRqDF6/Es2QLaCLR4PZBZWsxne0/nXGHpD2L/pb29PTkpczsj6QnZsT02s+6C77Gp5Ob66tX07dvpK9wsyXXBN9dXcp7u1lk6PDyUE+d3LEtZd8GzpIFOx08//wq9j3qN/WpPzr8/fvNa7gW4S1nKugueJQ2yi+BmqdI+6nKd345lKesueJa25u52OX319n612qUshaf7sWqyFMRSv93LUkjcBc/SdsgTsUtZKjguBfEktpNZitwFz9J20HmMphJyj7SvX1LjeYnTSB9+dvYhezPMMUbMUnjqLuSuqlUNDgOTJQn6uCSLAclchRJZ4gXb1NtkYQx5XNAsRe5CW4PDeJb6wN8vFSlcIXsbf7jsbTySp52S2N9/+XW5jH7y3HJFDbIUEnehocFhILOUgq6fgTYCLV6PZ8kW0EagxevxLNkC2gi0eD2eJVtAG4EWr+cxS47jKAk+LtkB2gi0eD2eJVtAG4EWr8ezZAtoI9Di9XiWbAFtBFq8Hs+SLaCNQIvX41myBbQRaPF6kLIUzbCSM7Ks6ecZYtm9U9sbGdZTio6tIOtnVN1jagC8LGXn+ZrSv1rdfzz+RM25mM+ibapDcyMb9ZSiVytENTMuL059L7MNoGRJEi2hJToayeopRZdWqLqb9bPAyxKN4xB7bMp6Q5JeRtbpKUWXVuDKBe0PHYGUJYnxvZ95i9iNN1RtjIzXo6FLK0SLKTuCmqVoZDerP4pKSmMjG/Vo8CwFxCzJCk/BcJYinRt/obaRjXo0+PNSQMnS+cl77gRc3on+ryn9d7fL9yfn9G8eB+gZiW6xGhvJ6il+lNCvFS4vTv093vPgm/70OwRT+rOvFmSWGhsZeNVRlo6tIEs++PdLKtD1M9BGoMXr8SzZAtoItHg9niVbQBuBFq/nMUuO4yjxLDlOGYLf49kB2gi0eD2eJVtAG4EWr8ezZAtoI9Di9XiWbAFtBFq8Hs+SLaCNQIvX41myBbQRaPF68LLEM6/k1DIg/QwZiWZh1jOSPVxZ+rbCYj7b29vrOGEcLEvrllij6CdomcDJ+ffRjmyhWr2HdYcrS8dWWK3u376avnt3VHWx4zBIWaLzlZ3mDKE/It3dMNQ0kj1cWTq2Am35vFx+7bheHSlLtI7t4OAF3eNZruk1Bs9SQWgfzgYeB0DKkizdRPXQ7K9RH8CzVAq5WLhqoaVhwLLEa0KjngGhP8KzVAqZn6qL8IdBypI8TZ6lIocrS5dWiIrgEr5GfQOyN0SlOiH0R3iWihD1hFC5psUASFkKT8tGy28SUPQT9JI6ex2t9068wWW7SyukVZ17VSYCy9I60PUz0EagxevxLNkC2gi0eD2eJVtAG4EWr+cxS47jKAk+LtkB2gi0eD2eJVtAG4EWr8ezZAtoI9Di9XiWbAFtBFq8Hs+SLaCNQIvX41myBbQRaPF6kLIkt1oheNqVNf1yC5N0Mks0HbPBQqxhPaXo0grRyey4RyBSliLkRCxT+u9ul0dH39ESgOw8y8b7qG/UU4qOWaIZhnKTq/agZgl6j83GWdqopxTdsxR8LeAWRLODzerP7kw8sFFfbSNVd0runiVfo/5s0kn1NvWPadropquqkdpdzcLzUtVNRIeBzFI6jtvUH+3rnCW6LlQ1MkaPhu7jUsgtDWwGXpayK70M6h/ZcZs9+NUOUrCRpV4LAQNilrJvokzpp9aNOq58xXR+8p7DE3XxGkayempgIUs+Lo2FrjrpHb8p/en3YLP5QmZJ/kKDm9WsnuJHCTael6p+gTYMWJbWga6fgTYCLV6PZ8kW0EagxevxLNkC2gi0eD2eJVtAG4EWr+cxS47jKAk+LtkB2gi0eD2eJVtAG4EWr8ezZAtoI9Di9XiWbAFtBFq8Hs+SLaCNQIvX41myBbQRaPF6wLIkp5bJWXnW9HN9hezCu471HqqWQ+jYCnIzIV9Xuxm5j7rlNeqr1f3H40/UnOnuQKH5GvWNekrRqxWiueGXF6e+L+AG7m6XvOO8zFUwliVJtvxAx3oPVcshdGmFjguWIpCyFEJYzGeTyfTPv/+K1lrb1L9uhUiveg/r9JSiSyvIK2xfwLIUQljMZ+k9sTX9/Fy38YaqTb2H8Xo0dGmFqtVgngVSluRofnlxCrH388Z6dC3rPYzRo8GzFFCyJO/1o5XJZvVvrEfX+CXK7tXH8+elbZBXIHoH2uxy/izubpfvT87p3zwOdKz3kNVT/CihXytENyn+Hm8U9LBk/Pul7KuFjvUeBl51lKVjK8iC6f79kgp0/Qy0EWjxejxLtoA2Ai1ej2fJFtBGoMXr8SzZAtoItHg9j1lyHEdJ8HHJDtBGoMXr8SzZAtoItHg9niVbQBuBFq/Hs2QLaCPQ4vV4lmwBbQRavB7Pki2gjUCL1wOWJZ7J1njL5OLI+gT6jXdpmqKcoHh5ccqbPsnPv7m+oulq6X8aWO07kkqtsM5dyGmuanAYpCzJZf3RqhUI/Yxc3xrVKtg6S4eHh/KE7FiWsu6CZ2lr5PollHoPWeSFIGrgrbN0cv49z0MPO5elrLvgWdoa2QUbL0ctS/FFjYv57PTiUq7z27EsZd0Fz5IGXr+0v//y4ODFDmQp/K+v0L81WQpiZeHuZSkk7oJnqQg+Lkm4t/GT2E5mKXIXPEtFgH73UON5idNIH3529oGzFL0Bw81SeOouJFeiUNngMJBZSuu8IeqnRi1yUZC9jVekU2+TBR7kcUGzFLkLbQ0Og5Ql+Z1MVBwDQr+EvRT5okz2Nv5w2dt4UUDaKfn58+tyGf3kuZUhGmQpJO5CQ4PDIGVpAHT9DLQRaPF6PEu2gDYCLV6PZ8kW0EagxevxLNkC2gi0eD2PWXIcR0nwcckO0EagxevxLNkC2gi0eD2eJVtAG4EWr8ezZAtoI9Di9XiWbAFtBFq8Hs+SLaCNQIvXYzpLNM8qnYtF7x/1ZRL6kroLNY1kD1eWvq1Aa9s6bhBoNEs04ZdWJnPzFy+T0IusO6KGkYHDlaVjK1DNgnfvjqpubj2M0SwR0eqU4st++pKuvQk1jWQPV5aOrUBLAJfLr9NXb3vtA42UJcS9nwfwLBWE1mU08DgAapZCiTIJffEslSIqq+L71Wbwcan24crSqxVkx5C5agxSlvx5qfjhytKlFaL1s0SX2zykLBUvk9AXz1IRoje64WkFiJYYzRLFJr3SlC2T0It17kLNd+INLttdWmExn0XvwaN6b80wmqXngq6fgTYCLV6PZ8kW0EagxevxLNkC2gi0eD2eJVtAG4EWr+cxS47jKAk+LtkB2gi0eD2eJVtAG4EWr8ezZAtoI9Di9XiWbAFtBFq8Hs+SLaCNQIvX41myBbQRaPF6TGcpW6KgcZmEGtxcX0XvUnkuZj0jvElR8X2HmI6twBsZE12qPhjN0kC9h2ZlEpohZ2dWMtJmhVzfLPVaTssYzRKRXSbQeKlCbaK1azWMUF2RBsvjPEvBs9SRaMlADSMU14ODF3T/U69Sj2cpeJZ6ka60qWFErpajBWCVHieMPC91WQgYPEt9SR9jKmUpWtu/S2sBCR+XNrDbWcou/6x3j0fjkmepHp6lbmTLEtQwIs9YWh2hIJ6lYDBL2RIFjcskVEXWc5ZUMrKuDntZPEvBYJaeC7p+BtoItHg9niVbQBuBFq/Hs2QLaCPQ4vV4lmwBbQRavJ7HLDmOoySE8H99OXGcgvwHsoA66UCW/lYAAAAASUVORK5CYII=" /> </span></span></span></span><br />
<br />
<span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: inherit;"><span style="font-family: Arial,Helvetica,sans-serif;">Note that I did add one more group (F) in addition to the others shown in the original, for testing purposes.</span></span></span></span></span><br />
<br />
<span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: inherit;"><span style="font-family: Arial,Helvetica,sans-serif;">I hope this helps anyone who happens to stumble across it. Enjoy!</span></span></span></span></span><br />
<span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: small;"><span style="font-family: inherit;"><span style="font-family: Arial,Helvetica,sans-serif;"> </span> </span></span></span></span>Anonymoushttp://www.blogger.com/profile/02484976284138761437noreply@blogger.com0tag:blogger.com,1999:blog-5453604484381773111.post-9756219030820292692014-07-16T12:11:00.001-05:002014-07-16T12:11:59.908-05:00The Mystery of the missing Registered Servers in SSMSI recently had an issue with my new installation of SSMS 2014. Right after I installed it, I imported my list of Registered Servers. I use this all the time to keep track of all of the several servers I manage. If you are interested. The below are two good articles about Registered Servers and why they are a great addition to your tool belt.<br />
Good basic article: <br />
<a href="http://sqlmag.com/sql-server/using-registered-servers-ssms" target="_blank">http://sqlmag.com/sql-server/using-registered-servers-ssms</a><br />
Pretty comprehensive article with examples of ways to do multi-server scripting.<br />
<a href="https://www.simple-talk.com/sql/sql-tools/registered-servers-and--central-management-server-stores/" target="_blank">https://www.simple-talk.com/sql/sql-tools/registered-servers-and--central-management-server-stores/</a><br />
<br />
So what was my problem?<br />
<br />
I was working with my list of Registered Servers when it disappeared. Poof! Everything gone. No root or anything to work with, and no way to get it to come back.<br />
<br />
At first this was irritating but not too bad, but the longer I went without my Registered Servers, the more I missed them.<br />
<br />
I could find nowhere online where anyone mentioned this problem, just mentioned turning on and off the window for Registered Servers, which wasn't my problem. Finally, I felt it was worth it and started trying to do repair installs on SSMS. In the end I did multiple repair/uninstall/reinstall cycles and even upgraded my install from just SSMS 2014 to the full Developer Edition.<br />
<br />
Nothing worked!<br />
<br />
It turns out that the actual file that controls the Registered Servers list is stored in your profile and that mine had somehow gotten corrupted, and if you uninstall and reinstall it doesn't do anything to it! It was not an easy file to find, though, afterwards, I saw that it is listed in the Simple Talk article, I only found that out afterwards.<br />
<br />
So, what is this file and where is it located? <br />
The file is RegSrvr.xml. Where it is located varies depending on your O/S (as mentioned in the Simple Talk article).<br />
On my system running Windows 7. It is located in:<br />
C:\Users\<login>\AppData\Roaming\Microsoft\Microsoft SQL Server\120\Tools\Shell<br />
<br />
Yeah, it isn't grouped with<br />
C:\Users\<login>\AppData\Local\Microsoft\SQL Server Management Studio<br />
where most of the other settings are. That would be too easy. And since I didn't know the name of the file, I couldn't just use search to find it.<br />
<br />
Finally, I did find it and copied over it with the one from my 2012 SSMS install which was still working. I'm still not clear how it got corrupted or why, but once I had a good copy, everything worked again.<br />
<br />
So, I'm posting this so that if anyone else has a similar problem that they will hopefully spend less time getting it fixed.Anonymoushttp://www.blogger.com/profile/02484976284138761437noreply@blogger.com0tag:blogger.com,1999:blog-5453604484381773111.post-83235775717394255622014-01-16T16:28:00.001-06:002014-01-16T16:28:15.178-06:00Looking for matching sets - Looking for help<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:AllowPNG/>
</o:OfficeDocumentSettings>
</xml><![endif]--><br />
<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true"
DefSemiHidden="true" DefQFormat="false" DefPriority="99"
LatentStyleCount="267">
<w:LsdException Locked="false" Priority="0" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" Priority="39" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" Name="toc 9"/>
<w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" Priority="10" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" Priority="11" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" Priority="22" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" Priority="59" SemiHidden="false"
UnhideWhenUsed="false" Name="Table Grid"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
table.MsoTableGrid
{mso-style-name:"Table Grid";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-priority:59;
mso-style-unhide:no;
border:solid windowtext 1.0pt;
mso-border-alt:solid windowtext .5pt;
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-border-insideh:.5pt solid windowtext;
mso-border-insidev:.5pt solid windowtext;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
</style>
<![endif]-->
<br />
<div class="MsoNormal">
I think that this problem has to have been solved before,
but I haven’t been able to find a solution on the internet.</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
This is a compensation problem. For work orders that contain
certain combinations of items, we want to award bonus points to our workers.
There are many possible combinations of work order items for which we want to
assign various amounts of bonus points. We don’t want to assign bonus points at
all unless a given work order contains one of the compensated combinations. </div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
The ultimate objective is to know what bonus points, if any
should be assigned to each work order.</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
If someone has seen something similar, I would love to see
it, or if you can find an exact solution, that would be fantastic. I’m putting the creation SQL at the end of this post, but the graphical version looks like the
below.</div>
<div class="MsoNormal">
The simplified work order information looks like this:</div>
<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; margin-left: 4.65pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184; width: 197px;">
<tbody>
<tr style="height: 15.0pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td nowrap="" style="border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">WORowId</span></div>
</td>
<td nowrap="" style="border-left: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">WONum</span></div>
</td>
<td nowrap="" style="border-left: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">ItemCode</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 1;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">1</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">1</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">101</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 2;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">2</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">1</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">300</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 3;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">3</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">2</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">300</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 4;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">4</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">3</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">300</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 5;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">5</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">3</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">6602</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 6;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">6</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">3</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">101</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 7;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">7</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">4</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">300</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 8;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">8</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">5</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">300</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 9;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">9</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">5</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">101</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 10;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">10</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">5</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">501A</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 11;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">11</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">6</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">101</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 12;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">12</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">7</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">101</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 13;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">13</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">7</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">300</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 14;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">14</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">8</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">101</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 15;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">15</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">8</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">300</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 16;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">16</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">8</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">501A</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 17;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">17</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">9</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">501A</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 18;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">18</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">10</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">8872</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 19;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">19</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">10</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">101</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 20;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">20</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">11</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">300</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 21;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">21</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">11</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">501A</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 22;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">22</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">11</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">101</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 23;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">23</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">11</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">101</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 24; mso-yfti-lastrow: yes;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 52.0pt;" valign="bottom" width="69">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">24</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 45.0pt;" valign="bottom" width="60">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">11</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 51.0pt;" valign="bottom" width="68">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">9954B</span></div>
</td>
</tr>
</tbody></table>
<br /><div class="MsoNormal">
<br />
The table that contains the groups is:</div>
<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; margin-left: 4.65pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184; width: 211px;">
<tbody>
<tr style="height: 15.0pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td nowrap="" style="border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 48.0pt;" valign="bottom" width="64">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">GroupId</span></div>
</td>
<td nowrap="" style="border-left: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 62.0pt;" valign="bottom" width="83">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">GroupName</span></div>
</td>
<td nowrap="" style="border-left: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 48.0pt;" valign="bottom" width="64">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">BonusPts</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 1;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 48.0pt;" valign="bottom" width="64">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">1</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 62.0pt;" valign="bottom" width="83">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">A</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 48.0pt;" valign="bottom" width="64">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">1</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 2;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 48.0pt;" valign="bottom" width="64">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">2</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 62.0pt;" valign="bottom" width="83">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">B</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 48.0pt;" valign="bottom" width="64">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">2.5</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 3;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 48.0pt;" valign="bottom" width="64">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">3</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 62.0pt;" valign="bottom" width="83">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">C</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 48.0pt;" valign="bottom" width="64">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">3.5</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 4;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 48.0pt;" valign="bottom" width="64">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">4</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 62.0pt;" valign="bottom" width="83">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">D</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 48.0pt;" valign="bottom" width="64">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">3.5</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 5; mso-yfti-lastrow: yes;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 48.0pt;" valign="bottom" width="64">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">5</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 62.0pt;" valign="bottom" width="83">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">E</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 48.0pt;" valign="bottom" width="64">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">5</span></div>
</td>
</tr>
</tbody></table>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
The table that specifies which combinations of item codes
belongs to which qualifier is:</div>
<br /><table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; margin-left: 4.65pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184; width: 211px;">
<tbody>
<tr style="height: 15.0pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td nowrap="" style="border: solid windowtext 1.0pt; height: 15.0pt; mso-border-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 65.0pt;" valign="bottom" width="87">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">QualGroupId</span></div>
</td>
<td nowrap="" style="border-left: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 43.0pt;" valign="bottom" width="57">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">GroupId</span></div>
</td>
<td nowrap="" style="border-left: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 50.0pt;" valign="bottom" width="67">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">ItemCode</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 1;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 65.0pt;" valign="bottom" width="87">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">1</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 43.0pt;" valign="bottom" width="57">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">1</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 50.0pt;" valign="bottom" width="67">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">101</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 2;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 65.0pt;" valign="bottom" width="87">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">2</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 43.0pt;" valign="bottom" width="57">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">2</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 50.0pt;" valign="bottom" width="67">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">101</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 3;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 65.0pt;" valign="bottom" width="87">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">3</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 43.0pt;" valign="bottom" width="57">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">2</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 50.0pt;" valign="bottom" width="67">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">300</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 4;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 65.0pt;" valign="bottom" width="87">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">4</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 43.0pt;" valign="bottom" width="57">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">3</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 50.0pt;" valign="bottom" width="67">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">101</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 5;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 65.0pt;" valign="bottom" width="87">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">5</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 43.0pt;" valign="bottom" width="57">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">3</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 50.0pt;" valign="bottom" width="67">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">300</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 6;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 65.0pt;" valign="bottom" width="87">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">6</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 43.0pt;" valign="bottom" width="57">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">3</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 50.0pt;" valign="bottom" width="67">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">501A</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 7;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 65.0pt;" valign="bottom" width="87">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">7</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 43.0pt;" valign="bottom" width="57">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">4</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 50.0pt;" valign="bottom" width="67">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">300</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 8;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 65.0pt;" valign="bottom" width="87">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">8</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 43.0pt;" valign="bottom" width="57">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">4</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 50.0pt;" valign="bottom" width="67">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">501A</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 9;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 65.0pt;" valign="bottom" width="87">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">9</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 43.0pt;" valign="bottom" width="57">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">5</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 50.0pt;" valign="bottom" width="67">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">6602</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 10;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 65.0pt;" valign="bottom" width="87">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">10</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 43.0pt;" valign="bottom" width="57">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">5</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 50.0pt;" valign="bottom" width="67">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">300</span></div>
</td>
</tr>
<tr style="height: 15.0pt; mso-yfti-irow: 11; mso-yfti-lastrow: yes;">
<td nowrap="" style="border-top: none; border: solid windowtext 1.0pt; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 65.0pt;" valign="bottom" width="87">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">11</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 43.0pt;" valign="bottom" width="57">
<div align="right" class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: right;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">5</span></div>
</td>
<td nowrap="" style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; height: 15.0pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 50.0pt;" valign="bottom" width="67">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
<span style="color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: "Times New Roman"; mso-hansi-font-family: Calibri;">101</span></div>
</td>
</tr>
</tbody></table>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
The desired final output should be:</div>
<table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184;">
<tbody>
<tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td style="border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 66.95pt;" valign="top" width="89">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
WONum</div>
</td>
<td style="border-left: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 220.45pt;" valign="top" width="294">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
BonusPoints</div>
</td>
<td style="border-left: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 191.4pt;" valign="top" width="255">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
GroupId</div>
</td>
</tr>
<tr style="mso-yfti-irow: 1;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 66.95pt;" valign="top" width="89">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
1</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 220.45pt;" valign="top" width="294">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
2.5</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 191.4pt;" valign="top" width="255">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
2</div>
</td>
</tr>
<tr style="mso-yfti-irow: 2;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 66.95pt;" valign="top" width="89">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
2</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 220.45pt;" valign="top" width="294">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
0</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 191.4pt;" valign="top" width="255">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
null</div>
</td>
</tr>
<tr style="mso-yfti-irow: 3;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 66.95pt;" valign="top" width="89">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
3</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 220.45pt;" valign="top" width="294">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
5</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 191.4pt;" valign="top" width="255">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
5</div>
</td>
</tr>
<tr style="mso-yfti-irow: 4;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 66.95pt;" valign="top" width="89">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
4</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 220.45pt;" valign="top" width="294">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
0</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 191.4pt;" valign="top" width="255">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
Null</div>
</td>
</tr>
<tr style="mso-yfti-irow: 5;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 66.95pt;" valign="top" width="89">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
5</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 220.45pt;" valign="top" width="294">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
3.5</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 191.4pt;" valign="top" width="255">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
3</div>
</td>
</tr>
<tr style="mso-yfti-irow: 6;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 66.95pt;" valign="top" width="89">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
6</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 220.45pt;" valign="top" width="294">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
1</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 191.4pt;" valign="top" width="255">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
1</div>
</td>
</tr>
<tr style="mso-yfti-irow: 7;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 66.95pt;" valign="top" width="89">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
7</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 220.45pt;" valign="top" width="294">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
2.5</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 191.4pt;" valign="top" width="255">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
2</div>
</td>
</tr>
<tr style="mso-yfti-irow: 8;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 66.95pt;" valign="top" width="89">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
8</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 220.45pt;" valign="top" width="294">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
3.5</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 191.4pt;" valign="top" width="255">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
3</div>
</td>
</tr>
<tr style="mso-yfti-irow: 9;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 66.95pt;" valign="top" width="89">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
9</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 220.45pt;" valign="top" width="294">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
0</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 191.4pt;" valign="top" width="255">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
Null</div>
</td>
</tr>
<tr style="mso-yfti-irow: 10;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 66.95pt;" valign="top" width="89">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
10</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 220.45pt;" valign="top" width="294">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
1</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 191.4pt;" valign="top" width="255">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
1</div>
</td>
</tr>
<tr style="mso-yfti-irow: 11; mso-yfti-lastrow: yes;">
<td style="border-top: none; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 66.95pt;" valign="top" width="89">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
11</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 220.45pt;" valign="top" width="294">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
0 (doesn’t match because of two 101’s)</div>
</td>
<td style="border-bottom: solid windowtext 1.0pt; border-left: none; border-right: solid windowtext 1.0pt; border-top: none; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding: 0in 5.4pt 0in 5.4pt; width: 191.4pt;" valign="top" width="255">
<div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;">
Null</div>
</td>
</tr>
</tbody></table>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Note: If a work order contains extra codes that are not in
any of the lists, then they are ignored. If it contains multiples of one of the
valid codes then it only matches if there is a group with the exact match.</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: "Courier New",Courier,monospace;"> CREATE TABLE [dbo].[WOs](<br /> [WORowId] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,<br /> [WONum] [int] NOT NULL,<br /> [ItemCode] [varchar](50) NOT NULL<br />)<br />CREATE TABLE [dbo].[Group](<br /> [GroupId] [int] NOT NULL PRIMARY KEY,<br /> [GroupName] [varchar](50) NOT NULL,<br /> [BonusPts] [decimal](18, 2) NOT NULL<br />)<br />CREATE TABLE [dbo].[QualifierGroups](<br /> [QualGroupId] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,<br /> [GroupId] [int] NOT NULL,<br /> [ItemCode] [varchar](50) NOT NULL<br />) <br /><br />SET IDENTITY_INSERT [dbo].[QualifierGroups] ON<br />INSERT INTO [dbo].[QualifierGroups] ([QualGroupId], [GroupId], [ItemCode]) VALUES (1, 1, '101')<br />INSERT INTO [dbo].[QualifierGroups] ([QualGroupId], [GroupId], [ItemCode]) VALUES (2, 2, '101')<br />INSERT INTO [dbo].[QualifierGroups] ([QualGroupId], [GroupId], [ItemCode]) VALUES (3, 2, '300')<br />INSERT INTO [dbo].[QualifierGroups] ([QualGroupId], [GroupId], [ItemCode]) VALUES (4, 3, '101')<br />INSERT INTO [dbo].[QualifierGroups] ([QualGroupId], [GroupId], [ItemCode]) VALUES (5, 3, '300')<br />INSERT INTO [dbo].[QualifierGroups] ([QualGroupId], [GroupId], [ItemCode]) VALUES (6, 3, '501A')<br />INSERT INTO [dbo].[QualifierGroups] ([QualGroupId], [GroupId], [ItemCode]) VALUES (7, 4, '300')<br />INSERT INTO [dbo].[QualifierGroups] ([QualGroupId], [GroupId], [ItemCode]) VALUES (8, 4, '501A')<br />INSERT INTO [dbo].[QualifierGroups] ([QualGroupId], [GroupId], [ItemCode]) VALUES (9, 5, '6602')<br />INSERT INTO [dbo].[QualifierGroups] ([QualGroupId], [GroupId], [ItemCode]) VALUES (10, 5, '300')<br />INSERT INTO [dbo].[QualifierGroups] ([QualGroupId], [GroupId], [ItemCode]) VALUES (11, 5, '101')<br />SET IDENTITY_INSERT [dbo].[QualifierGroups] OFF<br /><br />GO<br />SET IDENTITY_INSERT [dbo].[WOs] ON<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (1, 1, '101')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (2, 1, '300')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (3, 2, '300')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (4, 3, '300')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (5, 3, '6602')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (6, 3, '101')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (7, 4, '300')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (8, 5, '300')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (9, 5, '101')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (10, 5, '501A')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (11, 6, '101')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (12, 7, '101')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (13, 7, '300')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (14, 8, '101')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (15, 8, '300')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (16, 8, '501A')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (17, 9, '501A')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (18, 10, '8872')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (19, 10, '101')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (20, 11, '300')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (21, 11, '501A')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (22, 11, '101')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (23, 11, '101')<br />INSERT INTO [dbo].[WOs] ([WORowId], [WONum], [ItemCode]) VALUES (24, 11, '9954B')<br />SET IDENTITY_INSERT [dbo].[WOs] OFF<br /><br /><br />INSERT INTO [dbo].[Group] ([GroupId], [GroupName], [BonusPts]) VALUES (1, 'A', 1.00)<br />INSERT INTO [dbo].[Group] ([GroupId], [GroupName], [BonusPts]) VALUES (2, 'B', 2.50)<br />INSERT INTO [dbo].[Group] ([GroupId], [GroupName], [BonusPts]) VALUES (3, 'C', 3.50)<br />INSERT INTO [dbo].[Group] ([GroupId], [GroupName], [BonusPts]) VALUES (4, 'D', 3.50)<br />INSERT INTO [dbo].[Group] ([GroupId], [GroupName], [BonusPts]) VALUES (5, 'E', 5.00)</span></div>
Anonymoushttp://www.blogger.com/profile/02484976284138761437noreply@blogger.com1tag:blogger.com,1999:blog-5453604484381773111.post-32562028175253311522013-11-21T11:06:00.000-06:002013-11-21T11:06:12.937-06:00SP_WHO2 Replacement and SQL Text for all SPIDsI've always liked SP_WHO2. It is a simple command and has been around forever (well at least since 2000). Before SQL Server 2005 it was my go to command any time I thought I had blocking issues or needed quick information on a given SPID. I still use it, in spite of the additional DMVs that have largely superseded it because it is one quick command, it works on any version and I don't have to remember anything in the heat of battle.<br />
<br />
But it is old and has some flaws. I've had some scripts over the year to address those flaws and I have tried a number of DMVs, but I just never felt like the extra work was worth it.<br />
<br />
So, I recently found I needed to be able to see the actual command being currently executed by a given SPID. I found a number of solutions in my search, but when I found one by <a href="http://blog.sqlauthority.com/2009/07/19/sql-server-get-last-running-query-based-on-spid/" target="_blank">Pinal Dave</a>, I realized that with some slight modification I could make it work for all SPIDS at once if I used sys.sysprocesses. I built that, and then realized that I finally had an SP_WHO2 replacement that was worth the hassle. This gives me everything I ever wanted out of SP_WHO2 with the added benefit of being sortable and it shows the actual SQL being executed by each SPID.<br />
<br />
So, without further ado, my own humble addition to the SQL community:<br />
<br />
<span style="font-family: "Courier New",Courier,monospace;"> SELECT s.spid<br /> ,s.blocked<br /> ,s.status<br /> ,s.cpu<br /> ,s.memusage<br /> ,s.physical_io<br /> ,s.program_name<br /> ,s.hostname<br /> ,s.loginame<br /> ,s.last_batch<br /> ,s.waittime<br /> ,s.lastwaittype<br /> ,t.text SQLText<br /> FROM sys.sysprocesses S<br /> CROSS APPLY sys.dm_exec_sql_text(sql_handle) T<br /> WHERE s.spid >= 50<br /> ORDER BY s.blocked desc, s.spid</span><br />
<br />
<br />
<br />
<br />Anonymoushttp://www.blogger.com/profile/02484976284138761437noreply@blogger.com0tag:blogger.com,1999:blog-5453604484381773111.post-45764940973099129792013-10-23T13:07:00.000-05:002013-10-23T13:07:05.664-05:00SSRS and the perils of inline commentsI just was working with a report that one of my customers was building and was forcefully reminded of something I already knew, but had forgotten.<br />
<br />
The two types of comment notation in TSQL, namely "--" and "/* . . . */" are not entirely the same, and in certain places using the wrong one ( "--") can get you in big trouble.<br />
<br />
Here is the scenario: My customer was working on creating a fairly simple report that had a somewhat complex query behind it. The query had originally been developed and debugged in SSMS, where it ran just fine.<br />
<br />
He then pasted the tsql code into the query portion of the dataset in SSRS, using the "show as text" option. When run from there, it ran just fine. But when he tried to preview the report, it said that it couldn't process the dataset. So he contacted me.<br />
<br />
I won't go into all the things I tried that didn't work, but here is the bottom line:<br />
When he was developing this complex query he had put in a check and then commented it out using the "--" style comment. As long as the query was run in a formatted fashion, it ran fine, but when SSRS went to run the query, <em>it didn't run it in a formatted fashion!</em> Once SSRS saw that "--" it invalidated the rest of the statement (over half of the total code). As soon as I recognized this, I eliminated the comment and code and it ran without a problem.<br />
<br />
<h4>
So, the moral of the story is: Don't use the "--" style of code in any query you will run in SSRS!</h4>
<br />
Formatting of SQL code is not preserved in the running code. I had heard that this was a problem in other areas before, so I knew it in the back of my mind, and it was that which allowed me to recognize what was going on. I have heard other SQL authorities rail on the use of "--" in code before, advocating that you ALWAYS should us the "/* . . . */" style. I specifically remember it being mentioned as a problm in SSIS, but I had never run into this problem in SSRS before.<br />
<br />
So, I resolve from this day forth to join the /* camp and only use it for my comments.<br />
<br />
<h4>
Always use "/* . . . */" for your comments. It never hurts, and will sometimes save you time and pain.</h4>
<br />
That is all.Anonymoushttp://www.blogger.com/profile/02484976284138761437noreply@blogger.com0tag:blogger.com,1999:blog-5453604484381773111.post-39481414364665610272012-10-23T07:38:00.000-05:002012-10-23T07:44:14.200-05:00I'm an Official SQLServerCentral Author!Today my first article written for SQLServerCentral.com went live.<br />
The title is <a href="http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/94119/" target="_blank">A Versioning system for SSRS</a>. It outlines the way I attacked the problem we had at work with trying to do versioning of SSRS reports.<br />
<br />
This is something that I had been planning to do for a long time and I'm happy that I finally got it up and that so far it seems to have been well received. A lot of people have viewed it and so far and the ratings and comments have been quite positive.<br />
<br />
<br />
Now I just need to get that other article that I've been planning written up and out there as well.Anonymoushttp://www.blogger.com/profile/02484976284138761437noreply@blogger.com0tag:blogger.com,1999:blog-5453604484381773111.post-56312098308351541732012-08-23T07:39:00.000-05:002012-08-23T07:39:58.695-05:00And So It Begins . . . This blog is my attempt to give back and make available some of the things I've learned and gathered in my time working with databases and the SQL Server BI stack. I've worked with dBASE, FoxPro, MS-Access, SQL Server, MySQL, and Oracle.<br />
<br />
My current job revolves around SQL Server and Oracle, but other databases and tools show up on a semi-regular basis.<br />
<br />
<br />
I figure that for the inaugural post, I'll just include links to some of my favorite places for SQL Server info. When people start to get serious about SQL Server they usually ask, where to go for quality information. There is so much out there, and not all of it is correct, but I thought I'd list some of my favorite resources.<br />
<br />
<b>Go to sources for SQL Server questions:</b><br />
<a href="http://www.sqlservercentral.com/" target="_blank">SQL Server Central</a> - Excellent articles, commentary, and forums. My favorite resource SQL Server information. Run by Red Gate software, registration required.<br />
<br />
<a href="http://www.simple-talk.com/" target="_blank">Simple Talk</a> - Another Red Gate site. Lower quantity, but very high quality articles and scripts.<br />
<br />
<a href="http://www.sqlteam.com/" target="_blank">SQL Team</a> - Good forum site with quite a number of useful articles<br />
<br />
<a href="http://www.sqlmag.com/" target="_blank">http://www.sqlmag.com/</a> - Online version of the print magazine. Articles by some of the top people in the SQL Server world.<br />
<br />
<a href="http://www.mssqltips.com/" target="_blank">MS SQLTips</a> - Another excellent resource site.<br />
<br />
<a href="http://www.bidn.com/" target="_blank">BIDN</a> - BI Development Network - Fairly new site devoted to BI on the Microsoft stack.<br />
<br />
<br />
This is just scratching the surface of resources out on the internet, and it doesn't even begin to touch the many many excellent blogs by individual contributors, but it is a start.<br />
<br />
If this post helps even one other person, I'll be thrilled.<br />
<br />
Enjoy.<br />
<br />
<br />Anonymoushttp://www.blogger.com/profile/02484976284138761437noreply@blogger.com0