Executing Stored Procedures from Microsoft SQL Server

Hi Phil,

The first thing I'd check is whether the stored-procedure is actually
returning two things, rather than a single "set" - I've been caught by
this before!  Could you have a print statement hanging around from
debugging?  Are you using "return" or are you printing the results in
the stored-procedure?  I suggest that you create a small stored
procedure which only contains a simple "select top 10 * from
SimpleTable" to verify that it works.

cheers,
Sean O'Riordain

I am running R 2.3.0 on Windows 2000 connecting to MSSQL 8 via RODBC. When I try to execute a stored procedure via sqlQuery it returns no data. Regular queries work fine and the same query returns the desired results when pasted into the SQL query analyzer. Is it possible to execute a stored procedure?

Thanks,

Phil Smyth

_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB at stat.math.ethz.ch
https://stat.ethz.ch/mailman/listinfo/r-sig-db