Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jkozer26
Starting Member
1 Post |
 Posted - 2008-11-20 : 17:44:17
|
| Hi, I am having a few issues inserting an HTML string into a varchar(max) data type in SQL server 2005(Insert statement at the bottom). I am running into issues with repeat words for example one error message is:Msg 132, Level 15, State 1, Line 3The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure.Also, SQL server does not like the first equal sign:Msg 102, Level 15, State 1, Line 1Incorrect syntax near '='I think that the problem has to do with how sql server processes quotes and symbols and my HTML has MANY quotes. I hope there is a type of escape character I can use besides the obvious '/'. I also have the option of using a byte array to insert. In this case, I converted it into a string. Any tips or advice would be greatly appreciated. Thanks.INSERT INTO [HTMLStorageTest](ReportID=@ReportID, Input1=@Input1, Input2=@Input2, Expand_ca=@Expand_ca, HTML=@HTML), @ReportID : 5, @Input1 : foo , @Input2 : , @Expand_ca : False, @HTML : <br><br><html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:v="urn:schemas-microsoft-com:vml"><head><style>td{padding-right:1px;padding-left:1px;padding-top:0pt;padding-bottom:0pt;mso-height-rule:exactly;}tr{mso-height-rule:exactly;}}.s0{}.s1{font:normal 400 12.00pt "Arial";text-decoration:none;color:#000000;vertical-align:bottom;white-space:normal; text-align:right;}.s2{font:normal 400 12.00pt "Arial";text-decoration:none;color:#000000;vertical-align:bottom;white-space:normal; text-align:left;}.s3{font:normal 400 12.00pt "Arial";text-decoration:none;color:#000000;background:#000000;vertical-align:bottom;white-space:normal; text-align:left;}.s4{font:normal 700 15.00pt "Arial";text-decoration:none;color:#FFFFFF;background:#000000;vertical-align:bottom;white-space:normal; text-align:right;}.s5{font:normal 400 12.00pt "Arial";text-decoration:none;color:#000000;background:#C0C0C0;vertical-align:bottom;white-space:normal; text-align:left;}.s6{font:normal 700 9.00pt "Trebuchet MS";text-decoration:none;color:#000000;background:#C0C0C0;vertical-align:top;white-space:normal; text-align:left;}.s7{font:normal 400 9.00pt "Arial";text-decoration:none;color:#000000;background:#C0C0C0;vertical-align:top;white-space:normal; text-align:left;}.s8{font:normal 800 10.00pt "Arial";text-decoration:none;color:#000000;vertical-align:bottom;white-space:normal; text-align:left;}.s9{font:normal 700 9.00pt "Arial";text-decoration:none;color:#000000;vertical-align:top;white-space:nowrap; text-align:left;}.s10{font:normal 400 9.00pt "Arial";text-decoration:none;color:#000000;background:#F0F0F0;vertical-align:top;white-space:normal; text-align:left;}.s11{font:normal 400 9.00pt "Arial";text-decoration:none;color:#000000;vertical-align:bottom;white-space:normal; text-align:left;}.s12{font:normal 800 10.00pt "Arial";text-decoration:none;color:#000000;vertical-align:bottom;white-space:normal; text-align:right;}.s13{font:normal 200 9.00pt "Arial";text-decoration:none;color:#000000;vertical-align:top;white-space:normal; text-align:right;}.s14{font:normal 400 9.00pt "Arial";text-decoration:none;color:#000000;background:#F0F0F0;vertical-align:top;white-space:normal; text-align:right;}.s15{font:normal 400 9.00pt "Arial";text-decoration:none;color:#000000;vertical-align:bottom;white-space:normal; text-align:right;}.s16{font:normal 700 9.00pt "Arial";text-decoration:none;color:#000000;vertical-align:top;white-space:normal; text-align:right;}</style></head><body><table cellspacing=0 cellpadding=0 style='overflow:hidden;width:750px;'><tr valign='top' style='height:120.00pt'><td valign='top' style='padding-left:0pt;padding-right:0pt;width:750px;'><table cellspacing=0 cellpadding=0 style='overflow:hidden;width:750px;'><tr valign='top' style='height:33.00pt'><td valign='top' style='padding-left:0pt;padding-right:0pt;width:750px;'><table cellspacing=0 cellpadding=0 style='overflow:hidden;width:715px;'><tr valign='top' style='height:33.00pt'><td/><td valign='top' style='padding-left:0pt;padding-right:0pt;width:225px;'><TABLE cellspacing=0 class='s1' style='width:225px;'><TR style='height:34.00pt;'><TD CLASS='s1' STYLE="width:225px;"><img class='' style='height:34.00pt;width:168.75pt;' src='ImageService.aspx?path=fds_bitmaps:fslogo_black_bmp.bmp'/></TD></TR></TABLE></td></tr></table></td></tr><tr valign='top' style='height:5.00pt'><td valign='top' style='padding-left:0pt;padding-right:0pt;width:750px;'><TABLE cellspacing=0 class='s2' style='width:750px;'><TR style='height:5.00pt;'><TD CLASS='s2' STYLE="width:750px;"><img class='' style='height:5.00pt;width:562.50pt;' src='ImageService.aspx?path=fds_bitmaps:gradient_bar_long.bmp'/></TD></TR></TABLE></td></tr><tr valign='top' style='height:16.00pt'><td valign='top' style='padding-left:0pt;padding-right:0pt;width:750px;'><table cellspacing=0 cellpadding=0 style='overflow:hidden;width:750px;'><tr valign='top' style='height:16.00pt'><td valign='top' style='padding-left:0pt;padding-right:0pt;width:750px;'><table cellspacing=0 cellpadding=0 style='overflow:hidden;width:100.0%;'><tr valign='top' style='height:16.00pt'><td valign='top' style='padding-left:0pt;padding-right:0pt;width:100.0%;'><TABLE cellspacing=0 class='s3' style='width:100.0%;'><TR style='height:16.00pt;'><TD CLASS='s4' STYLE="height:16.00pt;width:100.0%;">Performance - Holdings</TD></TR></TABLE></td></tr></table></td></tr></table></td></tr><tr valign='top' style='height:5.00pt'><td valign='top' style='padding-left:0pt;padding-right:0pt;width:750px;'><TABLE cellspacing=0 class='s2' style='width:750px;'><TR style='height:5.00pt;'><TD CLASS='s2' STYLE="width:750px;"><img class='' style='height:5.00pt;width:562.50pt;' src='ImageService.aspx?path=fds_bitmaps:gradient_bar_long.bmp'/></TD></TR></TABLE></td></tr><tr valign='top' style='height:5.00pt'><td/></tr><tr valign='top' style='height:34.00pt'><td valign='top' style='padding-left:0pt;padding-right:0pt;width:750px;'><table cellspacing=0 cellpadding=0 style='overflow:hidden;width:750px;'><tr valign='top' style='height:33.00pt'><td valign='top' style='padding-left:0pt;padding-right:0pt;width:750px;'><TABLE cellspacing=0 class='s5' style='width:750px;'><TR style='height:10.00pt;'><TD CLASS='s5' STYLE="width:10px;"/><TD CLASS='s6' STYLE="height:10.00pt;width:90px;">Porfolio:#032;</TD><TD CLASS='s7' STYLE="height:10.00pt;width:345px;">U.S.#032;Large#032;Cap#032;Growth#032;Portfolio</TD><TD CLASS='s6' STYLE="height:10.00pt;width:90px;">Start#032;Date:#032;</TD><TD CLASS='s7' STYLE="height:10.00pt;width:215px;">11/12/2008</TD></TR><TR style='height:10.00pt;'><TD CLASS='s5' STYLE="width:10px;"/><TD CLASS='s6' STYLE="height:10.00pt;width:90px;">Grouping:#032;</TD><TD CLASS='s7' STYLE="height:10.00pt;width:345px;">Economic#032;Sector</TD><TD CLASS='s6' STYLE="height:10.00pt;width:90px;">End#032;Date:#032;</TD><TD CLASS='s7' STYLE="height:10.00pt;width:215px;">11/19/2008</TD></TR><TR style='height:10.00pt;'><TD CLASS='s5' STYLE="width:10px;"/><TD CLASS='s6' STYLE="height:10.00pt;width:90px;">Currency:#032;</TD><TD COLSPAN='3' CLASS='s7' STYLE="height:10.00pt;width:650px;">U.S.#032;Dollar</TD></TR></TABLE></td></tr></table></td></tr></table></td></tr><tr valign='top' style='height:12.50pt'><td/></tr><tr valign='top' style='height:610.00pt'><td valign='top' style='padding-left:0pt;padding-right:0pt;width:750px;'><table cellspacing=0 cellpadding=0 style='overflow:hidden;width:745px;'><tr valign='top' style='height:609.00pt'><td valign='top' style='padding-left:0pt;padding-right:0pt;width:745px;'><TABLE cellspacing=0 class='s2' style='width:745px;'><TR style='height:25.00pt;'><TD CLASS='s8' STYLE="height:25.00pt;width:295px;">#032;</TD><TD CLASS='s12' STYLE="height:25.00pt;width:90px;">Port.#032;Weight</TD><TD CLASS='s12' STYLE="height:25.00pt;width:90px;">Ending#032;Price</TD><TD CLASS='s12' STYLE="height:25.00pt;width:90px;">Price#032;Change#032;(%)</TD><TD CLASS='s12' STYLE="height:25.00pt;width:90px;">Port.#032;Market#032;Value</TD><TD CLASS='s12' STYLE="height:25.00pt;width:90px;">Dividend#10;Yield</TD></TR><TR style='height:10.00pt;'><TD CLASS='s9' STYLE="height:10.00pt;width:295px;">Commercial#032;Services</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">1.46</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;"></TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">-37.29</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">982,800.00</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">2.44</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Arbitron#032;Inc.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1.46</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">16.38</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-37.29</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">982,800.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">2.44</TD></TR><TR style='height:10.00pt;'><TD CLASS='s9' STYLE="height:10.00pt;width:295px;">Communications</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">0.71</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;"></TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">-6.98</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">474,144.00</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">6.49</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Verizon#032;Communications#032;Inc.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">0.71</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">26.94</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-6.98</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">474,144.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">6.49</TD></TR><TR style='height:10.00pt;'><TD CLASS='s9' STYLE="height:10.00pt;width:295px;">Consumer#032;Durables</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">4.44</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">-12.53</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">2,980,102.00</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">6.74</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Black#032;#038;#032;Decker#032;Corp.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1.92</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">36.78</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-7.93</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1,287,300.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">4.57</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Newell#032;Rubbermaid#032;Inc.</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">1.52</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">10.81</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">-9.99</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">1,018,302.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">7.77</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Harley-Davidson#032;Inc.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">13.49</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-23.13</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">674,500.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">9.34</TD></TR><TR style='height:10.00pt;'><TD CLASS='s9' STYLE="height:10.00pt;width:295px;">Consumer#032;Non-Durables</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">22.19</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">-0.21</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">14,908,218.00</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">3.35</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Altria#032;Group#032;Inc.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1.02</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">16.50</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-0.48</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">683,100.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">6.50</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Anheuser-Busch</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">1.83</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">68.58</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">3.39</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">1,227,582.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Campbell#032;Soup#032;Co.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">4.39</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">36.94</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">0.71</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">2,951,506.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">2.46</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Colgate-Palmolive#032;Co.</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">2.99</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">62.99</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">5.85</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">2,009,381.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">2.48</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;General#032;Mills#032;Inc.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">2.09</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">62.31</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-2.32</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1,401,975.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">2.65</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Kimberly-Clark#032;Corp.</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">4.66</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">56.08</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">-0.80</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">3,129,264.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">4.05</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Sara#032;Lee#032;Corp.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">0.50</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">8.82</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-6.96</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">335,160.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">4.76</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Coca-Cola#032;Co.</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">4.72</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">42.27</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">-3.56</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">3,170,250.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">3.50</TD></TR><TR style='height:10.00pt;'><TD CLASS='s9' STYLE="height:10.00pt;width:295px;">Consumer#032;Services</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">2.30</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">-7.90</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">1,548,397.00</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">6.32</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;H#038;R#032;Block#032;Inc.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1.24</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">16.61</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-4.70</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">830,500.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">3.48</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Gannett#032;Co.#032;Inc.</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">0.34</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">6.81</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">-21.72</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">229,497.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">23.49</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Time#032;Warner#032;Inc.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">0.73</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">8.14</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-5.46</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">488,400.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">3.07</TD></TR><TR style='height:10.00pt;'><TD CLASS='s9' STYLE="height:10.00pt;width:295px;">Electronic#032;Technology</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">8.02</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">-9.57</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">5,385,914.48</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">1.03</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Applied#032;Materials#032;Inc.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">0.93</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">8.42</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-15.38</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">627,290.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">2.85</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Cisco#032;Systems#032;Inc.</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">2.02</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">15.08</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">-8.88</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">1,357,200.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Electronics#032;for#032;Imaging#032;Inc.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1.28</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">8.63</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-6.50</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">863,000.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;LSI#032;Corp.</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">0.33</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">2.55</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">-18.79</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">224,910.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Micron#032;Technology#032;Inc.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">0.10</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">2.07</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-33.23</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">68,310.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Altera#032;Corp.</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">1.07</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">13.59</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">-7.74</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">720,270.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">1.32</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Motorola#032;Inc.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">0.36</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">3.44</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-12.91</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">240,800.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">5.81</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Texas#032;Instruments#032;Inc.</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">0.75</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">14.63</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">-10.57</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">503,272.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">2.80</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Dell#032;Inc.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">10.35</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-1.43</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">672,750.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;ADC#032;Telecommunications#032;Inc.</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">0.07</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">5.67</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">-6.90</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">44,549.98</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;JDS#032;Uniphase#032;Corp.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">0.02</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">2.58</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-19.12</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">14,512.50</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Sun#032;Microsystems#032;Inc.</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">0.07</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">3.27</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">-9.67</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">49,050.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style='height:10.00pt;'><TD CLASS='s9' STYLE="height:10.00pt;width:295px;">Finance</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">0.44</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">-2.75</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">298,820.00</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">3.59</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Marsh#032;#038;#032;McLennan#032;Cos.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">0.44</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">22.30</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-2.75</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">298,820.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">3.59</TD></TR><TR style='height:10.00pt;'><TD CLASS='s9' STYLE="height:10.00pt;width:295px;">Health#032;Services</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">0.64</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">-16.17</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">429,200.00</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">1.12</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;IMS#032;Health#032;Inc.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">0.64</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">10.73</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-16.17</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">429,200.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1.12</TD></TR><TR style='height:10.00pt;'><TD CLASS='s9' STYLE="height:10.00pt;width:295px;">Health#032;Technology</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">18.53</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">-2.18</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">12,450,735.00</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">3.50</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Merck#032;#038;#032;Co.#032;Inc.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">2.62</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">25.31</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-5.28</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1,761,576.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">6.01</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Medtronic#032;Inc.</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">1.86</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">31.20</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">-17.29</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">1,248,000.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">2.00</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Wyeth</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">2.55</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">33.34</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">2.77</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1,713,676.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">3.36</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Eli#032;Lilly#032;#038;#032;Co.</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">2.17</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">31.41</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">-1.81</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">1,457,424.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">5.84</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Bristol-Myers#032;Squibb#032;Co.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">0.44</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">20.27</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">3.68</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">297,969.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">6.12</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Abbott#032;Laboratories</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">7.30</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">54.52</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">0.04</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">4,906,800.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">2.58</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Schering-Plough#032;Corp.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1.59</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">15.35</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">4.92</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1,065,290.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1.69</TD></TR><TR style='height:10.00pt;'><TD CLASS='s9' STYLE="height:10.00pt;width:295px;">Non-Energy#032;Minerals</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">1.64</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">-12.71</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">1,102,816.00</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">7.13</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Freeport-McMoRan#032;Copper#032;#038;#032;Gold#032;Inc.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1.46</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">20.24</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-9.20</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">979,616.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">8.03</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;USG#032;Corp.</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">0.18</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">6.16</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">-33.26</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">123,200.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style='height:10.00pt;'><TD CLASS='s9' STYLE="height:10.00pt;width:295px;">Process#032;Industries</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">2.93</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">-11.58</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">1,971,200.00</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">1.44</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;FMC#032;Corp.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">2.93</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">32.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-11.58</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1,971,200.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1.44</TD></TR><TR style='height:10.00pt;'><TD CLASS='s9' STYLE="height:10.00pt;width:295px;">Producer#032;Manufacturing</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">9.62</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">-3.33</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">6,466,115.00</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">4.80</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;3M#032;Co.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">3.31</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">58.77</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-1.13</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">2,221,506.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">3.37</TD></TR></TABLE></td></tr></table></td></tr><tr valign='top' style='height:12.50pt'><td/></tr><tr valign='top' style='height:12.50pt'><td/></tr><tr valign='top' style='height:203.00pt'><td valign='top' style='padding-left:0pt;padding-right:0pt;width:750px;'><table cellspacing=0 cellpadding=0 style='overflow:hidden;width:745px;'><tr valign='top' style='height:202.00pt'><td valign='top' style='padding-left:0pt;padding-right:0pt;width:745px;'><TABLE cellspacing=0 class='s2' style='width:745px;'><TR style='height:25.00pt;'><TD CLASS='s8' STYLE="height:25.00pt;width:295px;">#032;</TD><TD CLASS='s12' STYLE="height:25.00pt;width:90px;">Port.#032;Weight</TD><TD CLASS='s12' STYLE="height:25.00pt;width:90px;">Ending#032;Price</TD><TD CLASS='s12' STYLE="height:25.00pt;width:90px;">Price#032;Change#032;(%)</TD><TD CLASS='s12' STYLE="height:25.00pt;width:90px;">Port.#032;Market#032;Value</TD><TD CLASS='s12' STYLE="height:25.00pt;width:90px;">Dividend#10;Yield</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;General#032;Electric#032;Co.</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">1.41</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">14.45</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">-11.30</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">949,365.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">8.58</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Emerson#032;Electric#032;Co.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">2.86</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">31.63</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1.18</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1,923,104.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">3.79</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Avery#032;Dennison#032;Corp.</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">2.04</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">27.72</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">-6.73</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">1,372,140.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">5.92</TD></TR><TR style='height:10.00pt;'><TD CLASS='s9' STYLE="height:10.00pt;width:295px;">Retail#032;Trade</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">11.71</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">-6.97</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">7,868,750.00</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">1.38</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;CVS#032;Caremark#032;Corp.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">3.32</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">27.84</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-1.69</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">2,227,200.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">0.93</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Gap#032;Inc.</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">1.05</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">10.09</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">-8.77</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">706,300.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">3.32</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Kroger#032;Co.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">3.56</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">26.60</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-0.71</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">2,394,000.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1.24</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Kohl's#032;Corp.</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">1.37</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">26.39</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">-8.59</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">923,650.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Target#032;Corp.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">2.41</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">26.96</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-18.99</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1,617,600.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">2.15</TD></TR><TR style='height:10.00pt;'><TD CLASS='s9' STYLE="height:10.00pt;width:295px;">Technology#032;Services</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">3.44</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">-5.83</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">2,314,100.00</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Yahoo!#032;Inc.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">0.54</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">9.14</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-11.61</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">365,600.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style='height:10.00pt;'><TD CLASS='s11' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Novell#032;Inc.</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">1.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">3.82</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">-7.95</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">668,500.00</TD><TD CLASS='s15' STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;Oracle#032;Corp.</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1.91</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">16.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">-2.85</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1,280,000.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style='height:10.00pt;'><TD CLASS='s9' STYLE="height:10.00pt;width:295px;">[Cash]</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">11.91</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">8,000,000.00</TD><TD CLASS='s13' STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style='height:10.00pt;'><TD CLASS='s10' STYLE="height:10.00pt;width:295px;">#032;#032;#032;U.S.#032;Dollar</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">11.91</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">1.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">8,000,000.00</TD><TD CLASS='s14' STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style='height:10.00pt;'><TD CLASS='s9' STYLE="height:10.00pt;width:295px;">#032;</TD><TD CLASS='s16' STYLE="height:10.00pt;width:90px;">100.00</TD><TD CLASS='s16' STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS='s16' STYLE="height:10.00pt;width:90px;">-4.98</TD><TD CLASS='s16' STYLE="height:10.00pt;width:90px;">67,181,311.48</TD><TD CLASS='s16' STYLE="height:10.00pt;width:90px;">3.18</TD></TR></TABLE></td></tr></table></td></tr></table></body></html><style>#StatTable { overflow:auto;border:solid 1px black;padding:5px;color:Black;font-size:12pt;height:150px;width:500px;}''</br></br> |
|
|
cvraghu
Posting Yak Master
187 Posts |
Posted - 2008-11-20 : 23:55:19
|
| I've never come across parameterized insert. Is this valid syntax? Also i don't see any delimiters for varchar values. Use proper string delimiters. |
 |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-11-21 : 11:16:26
|
| If you replace apostrophe before insert, e.g' replace with ~declare @HTML varchar(max)set @HTML ='<br><br><html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:v="urn:schemas-microsoft-com:vml"><head><style>td{padding-right:1px;padding-left:1px;padding-top:0pt;padding-bottom:0pt;mso-height-rule:exactly;}tr{mso-height-rule:exactly;}}.s0{}.s1{font:normal 400 12.00pt "Arial";text-decoration:none;color:#000000;vertical-align:bottom;white-space:normal; text-align:right;}.s2{font:normal 400 12.00pt "Arial";text-decoration:none;color:#000000;vertical-align:bottom;white-space:normal; text-align:left;}.s3{font:normal 400 12.00pt "Arial";text-decoration:none;color:#000000;background:#000000;vertical-align:bottom;white-space:normal; text-align:left;}.s4{font:normal 700 15.00pt "Arial";text-decoration:none;color:#FFFFFF;background:#000000;vertical-align:bottom;white-space:normal; text-align:right;}.s5{font:normal 400 12.00pt "Arial";text-decoration:none;color:#000000;background:#C0C0C0;vertical-align:bottom;white-space:normal; text-align:left;}.s6{font:normal 700 9.00pt "Trebuchet MS";text-decoration:none;color:#000000;background:#C0C0C0;vertical-align:top;white-space:normal; text-align:left;}.s7{font:normal 400 9.00pt "Arial";text-decoration:none;color:#000000;background:#C0C0C0;vertical-align:top;white-space:normal; text-align:left;}.s8{font:normal 800 10.00pt "Arial";text-decoration:none;color:#000000;vertical-align:bottom;white-space:normal; text-align:left;}.s9{font:normal 700 9.00pt "Arial";text-decoration:none;color:#000000;vertical-align:top;white-space:nowrap; text-align:left;}.s10{font:normal 400 9.00pt "Arial";text-decoration:none;color:#000000;background:#F0F0F0;vertical-align:top;white-space:normal; text-align:left;}.s11{font:normal 400 9.00pt "Arial";text-decoration:none;color:#000000;vertical-align:bottom;white-space:normal; text-align:left;}.s12{font:normal 800 10.00pt "Arial";text-decoration:none;color:#000000;vertical-align:bottom;white-space:normal; text-align:right;}.s13{font:normal 200 9.00pt "Arial";text-decoration:none;color:#000000;vertical-align:top;white-space:normal; text-align:right;}.s14{font:normal 400 9.00pt "Arial";text-decoration:none;color:#000000;background:#F0F0F0;vertical-align:top;white-space:normal; text-align:right;}.s15{font:normal 400 9.00pt "Arial";text-decoration:none;color:#000000;vertical-align:bottom;white-space:normal; text-align:right;}.s16{font:normal 700 9.00pt "Arial";text-decoration:none;color:#000000;vertical-align:top;white-space:normal; text-align:right;}</style></head><body><table cellspacing=0 cellpadding=0 style=~overflow:hidden;width:750px;~><tr valign=~top~ style=~height:120.00pt~><td valign=~top~ style=~padding-left:0pt;padding-right:0pt;width:750px;~><table cellspacing=0 cellpadding=0 style=~overflow:hidden;width:750px;~><tr valign=~top~ style=~height:33.00pt~><td valign=~top~ style=~padding-left:0pt;padding-right:0pt;width:750px;~><table cellspacing=0 cellpadding=0 style=~overflow:hidden;width:715px;~><tr valign=~top~ style=~height:33.00pt~><td/><td valign=~top~ style=~padding-left:0pt;padding-right:0pt;width:225px;~><TABLE cellspacing=0 class=~s1~ style=~width:225px;~><TR style=~height:34.00pt;~><TD CLASS=~s1~ STYLE="width:225px;"><img class=~~ style=~height:34.00pt;width:168.75pt;~ src=~ImageService.aspx?path=fds_bitmaps:fslogo_black_bmp.bmp~/></TD></TR></TABLE></td></tr></table></td></tr><tr valign=~top~ style=~height:5.00pt~><td valign=~top~ style=~padding-left:0pt;padding-right:0pt;width:750px;~><TABLE cellspacing=0 class=~s2~ style=~width:750px;~><TR style=~height:5.00pt;~><TD CLASS=~s2~ STYLE="width:750px;"><img class=~~ style=~height:5.00pt;width:562.50pt;~ src=~ImageService.aspx?path=fds_bitmaps:gradient_bar_long.bmp~/></TD></TR></TABLE></td></tr><tr valign=~top~ style=~height:16.00pt~><td valign=~top~ style=~padding-left:0pt;padding-right:0pt;width:750px;~><table cellspacing=0 cellpadding=0 style=~overflow:hidden;width:750px;~><tr valign=~top~ style=~height:16.00pt~><td valign=~top~ style=~padding-left:0pt;padding-right:0pt;width:750px;~><table cellspacing=0 cellpadding=0 style=~overflow:hidden;width:100.0%;~><tr valign=~top~ style=~height:16.00pt~><td valign=~top~ style=~padding-left:0pt;padding-right:0pt;width:100.0%;~><TABLE cellspacing=0 class=~s3~ style=~width:100.0%;~><TR style=~height:16.00pt;~><TD CLASS=~s4~ STYLE="height:16.00pt;width:100.0%;">Performance - Holdings</TD></TR></TABLE></td></tr></table></td></tr></table></td></tr><tr valign=~top~ style=~height:5.00pt~><td valign=~top~ style=~padding-left:0pt;padding-right:0pt;width:750px;~><TABLE cellspacing=0 class=~s2~ style=~width:750px;~><TR style=~height:5.00pt;~><TD CLASS=~s2~ STYLE="width:750px;"><img class=~~ style=~height:5.00pt;width:562.50pt;~ src=~ImageService.aspx?path=fds_bitmaps:gradient_bar_long.bmp~/></TD></TR></TABLE></td></tr><tr valign=~top~ style=~height:5.00pt~><td/></tr><tr valign=~top~ style=~height:34.00pt~><td valign=~top~ style=~padding-left:0pt;padding-right:0pt;width:750px;~><table cellspacing=0 cellpadding=0 style=~overflow:hidden;width:750px;~><tr valign=~top~ style=~height:33.00pt~><td valign=~top~ style=~padding-left:0pt;padding-right:0pt;width:750px;~><TABLE cellspacing=0 class=~s5~ style=~width:750px;~><TR style=~height:10.00pt;~><TD CLASS=~s5~ STYLE="width:10px;"/><TD CLASS=~s6~ STYLE="height:10.00pt;width:90px;">Porfolio:#032;</TD><TD CLASS=~s7~ STYLE="height:10.00pt;width:345px;">U.S.#032;Large#032;Cap#032;Growth#032;Portfolio</TD><TD CLASS=~s6~ STYLE="height:10.00pt;width:90px;">Start#032;Date:#032;</TD><TD CLASS=~s7~ STYLE="height:10.00pt;width:215px;">11/12/2008</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s5~ STYLE="width:10px;"/><TD CLASS=~s6~ STYLE="height:10.00pt;width:90px;">Grouping:#032;</TD><TD CLASS=~s7~ STYLE="height:10.00pt;width:345px;">Economic#032;Sector</TD><TD CLASS=~s6~ STYLE="height:10.00pt;width:90px;">End#032;Date:#032;</TD><TD CLASS=~s7~ STYLE="height:10.00pt;width:215px;">11/19/2008</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s5~ STYLE="width:10px;"/><TD CLASS=~s6~ STYLE="height:10.00pt;width:90px;">Currency:#032;</TD><TD COLSPAN=~3~ CLASS=~s7~ STYLE="height:10.00pt;width:650px;">U.S.#032;Dollar</TD></TR></TABLE></td></tr></table></td></tr></table></td></tr><tr valign=~top~ style=~height:12.50pt~><td/></tr><tr valign=~top~ style=~height:610.00pt~><td valign=~top~ style=~padding-left:0pt;padding-right:0pt;width:750px;~><table cellspacing=0 cellpadding=0 style=~overflow:hidden;width:745px;~><tr valign=~top~ style=~height:609.00pt~><td valign=~top~ style=~padding-left:0pt;padding-right:0pt;width:745px;~><TABLE cellspacing=0 class=~s2~ style=~width:745px;~><TR style=~height:25.00pt;~><TD CLASS=~s8~ STYLE="height:25.00pt;width:295px;">#032;</TD><TD CLASS=~s12~ STYLE="height:25.00pt;width:90px;">Port.#032;Weight</TD><TD CLASS=~s12~ STYLE="height:25.00pt;width:90px;">Ending#032;Price</TD><TD CLASS=~s12~ STYLE="height:25.00pt;width:90px;">Price#032;Change#032;(%)</TD><TD CLASS=~s12~ STYLE="height:25.00pt;width:90px;">Port.#032;Market#032;Value</TD><TD CLASS=~s12~ STYLE="height:25.00pt;width:90px;">Dividend#10;Yield</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s9~ STYLE="height:10.00pt;width:295px;">Commercial#032;Services</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">1.46</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;"></TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">-37.29</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">982,800.00</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">2.44</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Arbitron#032;Inc.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1.46</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">16.38</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-37.29</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">982,800.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">2.44</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s9~ STYLE="height:10.00pt;width:295px;">Communications</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">0.71</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;"></TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">-6.98</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">474,144.00</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">6.49</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Verizon#032;Communications#032;Inc.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">0.71</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">26.94</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-6.98</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">474,144.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">6.49</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s9~ STYLE="height:10.00pt;width:295px;">Consumer#032;Durables</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">4.44</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">-12.53</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">2,980,102.00</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">6.74</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Black#032;#038;#032;Decker#032;Corp.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1.92</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">36.78</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-7.93</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1,287,300.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">4.57</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Newell#032;Rubbermaid#032;Inc.</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">1.52</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">10.81</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">-9.99</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">1,018,302.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">7.77</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Harley-Davidson#032;Inc.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">13.49</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-23.13</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">674,500.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">9.34</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s9~ STYLE="height:10.00pt;width:295px;">Consumer#032;Non-Durables</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">22.19</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">-0.21</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">14,908,218.00</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">3.35</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Altria#032;Group#032;Inc.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1.02</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">16.50</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-0.48</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">683,100.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">6.50</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Anheuser-Busch</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">1.83</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">68.58</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">3.39</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">1,227,582.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Campbell#032;Soup#032;Co.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">4.39</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">36.94</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">0.71</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">2,951,506.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">2.46</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Colgate-Palmolive#032;Co.</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">2.99</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">62.99</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">5.85</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">2,009,381.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">2.48</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;General#032;Mills#032;Inc.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">2.09</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">62.31</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-2.32</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1,401,975.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">2.65</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Kimberly-Clark#032;Corp.</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">4.66</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">56.08</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">-0.80</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">3,129,264.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">4.05</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Sara#032;Lee#032;Corp.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">0.50</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">8.82</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-6.96</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">335,160.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">4.76</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Coca-Cola#032;Co.</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">4.72</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">42.27</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">-3.56</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">3,170,250.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">3.50</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s9~ STYLE="height:10.00pt;width:295px;">Consumer#032;Services</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">2.30</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">-7.90</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">1,548,397.00</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">6.32</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;H#038;R#032;Block#032;Inc.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1.24</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">16.61</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-4.70</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">830,500.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">3.48</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Gannett#032;Co.#032;Inc.</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">0.34</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">6.81</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">-21.72</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">229,497.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">23.49</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Time#032;Warner#032;Inc.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">0.73</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">8.14</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-5.46</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">488,400.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">3.07</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s9~ STYLE="height:10.00pt;width:295px;">Electronic#032;Technology</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">8.02</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">-9.57</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">5,385,914.48</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">1.03</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Applied#032;Materials#032;Inc.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">0.93</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">8.42</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-15.38</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">627,290.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">2.85</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Cisco#032;Systems#032;Inc.</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">2.02</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">15.08</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">-8.88</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">1,357,200.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Electronics#032;for#032;Imaging#032;Inc.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1.28</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">8.63</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-6.50</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">863,000.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;LSI#032;Corp.</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">0.33</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">2.55</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">-18.79</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">224,910.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Micron#032;Technology#032;Inc.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">0.10</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">2.07</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-33.23</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">68,310.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Altera#032;Corp.</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">1.07</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">13.59</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">-7.74</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">720,270.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">1.32</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Motorola#032;Inc.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">0.36</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">3.44</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-12.91</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">240,800.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">5.81</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Texas#032;Instruments#032;Inc.</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">0.75</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">14.63</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">-10.57</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">503,272.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">2.80</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Dell#032;Inc.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">10.35</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-1.43</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">672,750.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;ADC#032;Telecommunications#032;Inc.</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">0.07</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">5.67</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">-6.90</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">44,549.98</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;JDS#032;Uniphase#032;Corp.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">0.02</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">2.58</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-19.12</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">14,512.50</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Sun#032;Microsystems#032;Inc.</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">0.07</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">3.27</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">-9.67</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">49,050.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s9~ STYLE="height:10.00pt;width:295px;">Finance</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">0.44</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">-2.75</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">298,820.00</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">3.59</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Marsh#032;#038;#032;McLennan#032;Cos.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">0.44</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">22.30</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-2.75</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">298,820.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">3.59</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s9~ STYLE="height:10.00pt;width:295px;">Health#032;Services</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">0.64</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">-16.17</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">429,200.00</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">1.12</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;IMS#032;Health#032;Inc.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">0.64</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">10.73</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-16.17</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">429,200.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1.12</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s9~ STYLE="height:10.00pt;width:295px;">Health#032;Technology</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">18.53</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">-2.18</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">12,450,735.00</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">3.50</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Merck#032;#038;#032;Co.#032;Inc.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">2.62</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">25.31</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-5.28</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1,761,576.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">6.01</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Medtronic#032;Inc.</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">1.86</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">31.20</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">-17.29</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">1,248,000.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">2.00</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Wyeth</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">2.55</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">33.34</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">2.77</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1,713,676.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">3.36</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Eli#032;Lilly#032;#038;#032;Co.</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">2.17</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">31.41</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">-1.81</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">1,457,424.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">5.84</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Bristol-Myers#032;Squibb#032;Co.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">0.44</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">20.27</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">3.68</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">297,969.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">6.12</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Abbott#032;Laboratories</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">7.30</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">54.52</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">0.04</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">4,906,800.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">2.58</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Schering-Plough#032;Corp.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1.59</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">15.35</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">4.92</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1,065,290.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1.69</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s9~ STYLE="height:10.00pt;width:295px;">Non-Energy#032;Minerals</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">1.64</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">-12.71</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">1,102,816.00</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">7.13</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Freeport-McMoRan#032;Copper#032;#038;#032;Gold#032;Inc.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1.46</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">20.24</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-9.20</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">979,616.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">8.03</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;USG#032;Corp.</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">0.18</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">6.16</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">-33.26</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">123,200.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s9~ STYLE="height:10.00pt;width:295px;">Process#032;Industries</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">2.93</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">-11.58</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">1,971,200.00</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">1.44</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;FMC#032;Corp.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">2.93</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">32.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-11.58</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1,971,200.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1.44</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s9~ STYLE="height:10.00pt;width:295px;">Producer#032;Manufacturing</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">9.62</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">-3.33</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">6,466,115.00</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">4.80</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;3M#032;Co.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">3.31</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">58.77</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-1.13</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">2,221,506.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">3.37</TD></TR></TABLE></td></tr></table></td></tr><tr valign=~top~ style=~height:12.50pt~><td/></tr><tr valign=~top~ style=~height:12.50pt~><td/></tr><tr valign=~top~ style=~height:203.00pt~><td valign=~top~ style=~padding-left:0pt;padding-right:0pt;width:750px;~><table cellspacing=0 cellpadding=0 style=~overflow:hidden;width:745px;~><tr valign=~top~ style=~height:202.00pt~><td valign=~top~ style=~padding-left:0pt;padding-right:0pt;width:745px;~><TABLE cellspacing=0 class=~s2~ style=~width:745px;~><TR style=~height:25.00pt;~><TD CLASS=~s8~ STYLE="height:25.00pt;width:295px;">#032;</TD><TD CLASS=~s12~ STYLE="height:25.00pt;width:90px;">Port.#032;Weight</TD><TD CLASS=~s12~ STYLE="height:25.00pt;width:90px;">Ending#032;Price</TD><TD CLASS=~s12~ STYLE="height:25.00pt;width:90px;">Price#032;Change#032;(%)</TD><TD CLASS=~s12~ STYLE="height:25.00pt;width:90px;">Port.#032;Market#032;Value</TD><TD CLASS=~s12~ STYLE="height:25.00pt;width:90px;">Dividend#10;Yield</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;General#032;Electric#032;Co.</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">1.41</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">14.45</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">-11.30</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">949,365.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">8.58</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Emerson#032;Electric#032;Co.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">2.86</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">31.63</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1.18</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1,923,104.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">3.79</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Avery#032;Dennison#032;Corp.</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">2.04</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">27.72</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">-6.73</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">1,372,140.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">5.92</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s9~ STYLE="height:10.00pt;width:295px;">Retail#032;Trade</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">11.71</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">-6.97</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">7,868,750.00</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">1.38</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;CVS#032;Caremark#032;Corp.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">3.32</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">27.84</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-1.69</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">2,227,200.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">0.93</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Gap#032;Inc.</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">1.05</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">10.09</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">-8.77</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">706,300.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">3.32</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Kroger#032;Co.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">3.56</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">26.60</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-0.71</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">2,394,000.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1.24</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Kohl~s#032;Corp.</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">1.37</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">26.39</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">-8.59</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">923,650.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Target#032;Corp.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">2.41</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">26.96</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-18.99</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1,617,600.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">2.15</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s9~ STYLE="height:10.00pt;width:295px;">Technology#032;Services</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">3.44</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">-5.83</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">2,314,100.00</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Yahoo!#032;Inc.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">0.54</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">9.14</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-11.61</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">365,600.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s11~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Novell#032;Inc.</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">1.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">3.82</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">-7.95</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">668,500.00</TD><TD CLASS=~s15~ STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;Oracle#032;Corp.</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1.91</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">16.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">-2.85</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1,280,000.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s9~ STYLE="height:10.00pt;width:295px;">[Cash]</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">11.91</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">8,000,000.00</TD><TD CLASS=~s13~ STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s10~ STYLE="height:10.00pt;width:295px;">#032;#032;#032;U.S.#032;Dollar</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">11.91</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">1.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">8,000,000.00</TD><TD CLASS=~s14~ STYLE="height:10.00pt;width:90px;">--</TD></TR><TR style=~height:10.00pt;~><TD CLASS=~s9~ STYLE="height:10.00pt;width:295px;">#032;</TD><TD CLASS=~s16~ STYLE="height:10.00pt;width:90px;">100.00</TD><TD CLASS=~s16~ STYLE="height:10.00pt;width:90px;">--</TD><TD CLASS=~s16~ STYLE="height:10.00pt;width:90px;">-4.98</TD><TD CLASS=~s16~ STYLE="height:10.00pt;width:90px;">67,181,311.48</TD><TD CLASS=~s16~ STYLE="height:10.00pt;width:90px;">3.18</TD></TR></TABLE></td></tr></table></td></tr></table></body></html><style>#StatTable { overflow:auto;border:solid 1px black;padding:5px;color:Black;font-size:12pt;height:150px;width:500px;}~~</br></br>'INSERT INTO dbo.table1( HTML) values (@HTML) |
|
|
|
|
|
|
|
|
Storing HTML string in a varChar(MAX) datatype