Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
sub Trigger
Set conn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
' String connection
strConn = "Connection Name"
' Open the connection
conn.Open strConn
parameter1= date1
parameter2= date2
' Execute the stored procedure
sqlQuery = "EXEC [dbo].[GetDatename] '2013/11/1','2013/2/2','25' "
rs.Open sqlQuery, conn, adOpenForwardOnly
end sub
It is not possible to use a macro to load data into QlikView. You should do it in the load script instead, using
SQL EXEC [dbo].[GetDatename] '2013/11/1','2013/2/2','25' ;
Read more here:How to pass variable to a SqlServer stored proc
HIC
Hi Sunil,
Instead of macro try like this in Qlikview script, it returns the resultset and stores in a table
TableName:
SQL EXEC [dbo].[GetDatename] '2013/11/1','2013/2/2','25' ;
Hope this helps you.
Regards,
Jagan.