How to call store procedure sql in QlikView

[#1]

Hi , I need to call a store procedure de sql in QlikView.

Buenas Tardes alquien me podra ayudar con un detalle deseo cargar un Store Procedure de SQL desde QlikView

Thanks,

[Josh_Good · Accepted solution]

If you are using an OLE DB connection then you need to use write mode in the connection string (see this post for more info http://community.qlik.com/thread/3223).  I find it easier to just use an ODBC connection.

Once connected the format is:

Load

Field1

Field2

...

;

Sql Exec StoredProcedureName 'Variable1', 'Variable2'

;

Hope that helps.

[#3]

Thanks Josh,