Re: [R] Execute SQL Stored Procedure in R

On Nov 24, 2010, at 9:07 PM, Suphajak Ngamlak wrote: Dear all, I would like R to retrieve a table resulting from execute sql stored procedures. What function can I use? Can RODBC do it. You might try looking at the package RSQLiite.extfuns I tried channel1 <- odbcConnect("ptsecmstqa0

[R] Execute SQL Stored Procedure in R

Dear all, I would like R to retrieve a table resulting from execute sql stored procedures. What function can I use? Can RODBC do it. I tried channel1 <- odbcConnect("ptsecmstqa01-alpha") query <- paste("execute DB.dbo.usp_test") Data<- sqlQuery(channel1, query) However, it returned blank. Be