I am trying to create custom query in SP2010 called company announcement. I would like to include the profile picture of the author from the sharepoint user profile. Any help would be great! _blank
<xsl:variable name="bodyContent">
<xsl:call-template name="removeMarkup">
<xsl:with-param name="string" select="@PublishingPageContent"/>
</xsl:call-template>
</xsl:variable>
<table cellpadding="0" cellspacing="0" width="100%">
<tr>
<td class="S2StyleTitle" colspan="2">
<xsl:call-template name="OuterTemplate.CallPresenceStatusIconTemplate"/>
<a href="{$SafeLinkUrl}" target="{$LinkTarget}" title="{@LinkToolTip}">
<strong><xsl:value-of select="$DisplayTitle"/> - <xsl:value-of select="$Created"/></strong></a>
...
</td>
</tr>
<tr class="S2StyleBorder">
<xsl:if test="string-length($SafeImageUrl) != 0">
<td class="S2StyleImage">
<a href="{$SafeLinkUrl}" target="{$LinkTarget}">
<img class="image" src="{$SafeImageUrl}" alt="{@ImageUrlAltText}" />
</a>
</td>
</xsl:if>
<td class="S2StyleDescription" valign="top">
<xsl:value-of select="substring($bodyContent,1,100)"/>... (<a href="{$SafeLinkUrl}" mce_href="{$SafeLinkUrl}" target="{$LinkTarget}" title="{@LinkToolTip}">more</a>)
</td>
</tr>
</table>