Hi,

This way of variable declaration is working fine:

 <xsl:variable name="Brandsqlresult"  select="jesper.sql:SQLXml($GetBrandPagewise)"/>

Here variable GetBrandPagewise variable get parsed and return a  assign that value to Brandsqlresult.

and second way assigning values based on condition:

   <xsl:variable name="Brandsqlresult">
          <xsl:choose>
            <xsl:when test="$SqlSession=''">
              <xsl:value-of  select="jesper.sql:SQLXml($GetBrandPagewise)"/>
            </xsl:when>
            <xsl:otherwise>
              <xsl:value-of select="jesper.sql:SQLXml($SqlSession)"/>
            </xsl:otherwise>
          </xsl:choose>
        </xsl:variable>

but here, Brandsqlresult is assigned with empty when i checking for When condition is true.

I have no idea where i am commiting a mistake.