Stored Procedure Parameters SQL

[#1]

Hello

I used stored procedures to bring my qlikview data, and it always works, now I need to pass a parameter which is the name of the user and the domain

but does not work, you can be wrong?

Thanks, regards

Cesar Estrada

vUserx = OSUser();

OLEDB CONNECT TO [Provider=SQLNCLI10.1;Integrated Security="";Persist Security Info=...............................................];

sql exec  ('[SERVER\XXX].[DBASE].[dbo].[gtStep1O] vUserx ' ) ;

[pgrenier · Accepted solution]

If you would like QlikView to send the contents of the variable through the SQL EXEC statement, you might want to add $() around the variable name, such as:

sql exec  ('[SERVER\XXX].[DBASE].[dbo].[gtStep1O] $(vUserx) ' ) ;

Cheers,

Philippe

[#3]

Hi Philippe:

when execute the script return this error

ErrorSource: Microsoft SQL Server Native Client 10.0, ErrorMsg: Incorrect syntax near '\'.

sql exec  ('[SERVER\XXX].[DBASE].[dbo].[gtpaso1O] DOMAIN\cestrada ' )

Thanks!

César

[#4]

Hi

sql exec  ('[SERVER\XXX].[DBASE].[dbo].[gtStep1O] "$(vUserx)"  ' )

Now Work Perfect!!

Thanks Philippe!!

Regards

César

[pgrenier]

Good catch César