This problem is solved. At the top it is necessary to add query, like this
<query name="Product" rowelementname="ProductInCampaign" runif="showproduct">
<sql>
<![CDATA[
exec dbo.aspdnsf_getCampaignData @ProductID
]]>
</sql>
<queryparam paramname="@ProductID" paramtype="request" requestparamname="ProductID" sqldatatype="int" defvalue="0" validationpattern="" />
</query>
then xsl template
<xsl:template name="ProductInCampaignID" xmlns:xsl="#unknown">
<xsl:for-each select="/root/Product/ProductInCampaign">
<div class="CampId">
<xsl:value-of select="FK_Campaign" />
<p>fdsfas</p>
</div>
</xsl:for-each>
</xsl:template>
and call this template
<xsl:call-template name="ProductInCampaignID" xmlns:xsl="#unknown"></xsl:call-template>
Thanks for the help Member 10272815 :)