Based on the feedback  on this forum "how to use stored procedure" using Stonefield SDK. I had created the report using virtual table / stored procedure approach works fine.

when I need data from two stored procedure this apprach is not working.

I have created two virtual table and their scripts call individual stored procedure.

Error message “The query failed, Alias “zzx” is not found.

What is the correct approach for  this kind of scenario?

Thanks in advance

Tushar

there are two stored prcedure created

jnk - which displays current date

jnk1- which diplays the current version of sql server

created two virtual tables

jnk and jnkversion

following are their respective scripts

jnk.select

function Main(SQApplication, Database, SelectStatement, CursorName)
' create a result set into XML
Main = XMLResults
Main = Database.ExecuteSQLStatement("exec [jnk]")
end function

jnkversion.select

function Main(SQApplication, Database, SelectStatement, CursorName)
' create a result set into XML
Main = XMLResults
Main = Database.ExecuteSQLStatement("exec [jnk1]")
end function

both stored proc through virtual table runs fine individually.

but combined report results into error