Creating SQL Stored Procedures via SQL Server is easier than you might have originally thought, so let us explain what to do.

How do I go about creating a dataset for this report that uses a stored procedure/sql view which will pull out a dynamic list of tables to query from? My goal is to be able to select "Server1 ...

We've got a strange problem here and I'm hoping someone has some kind of idea as to what could be causing it.We've got a stored procedure in Sql Server 2005. It's not terribly complicated but it's ...

When PROC SQL executes the view, the stored query assigns the libref and establishes the DBMS connection using the information in the LIBNAME statement. The scope of the libref is local to the view, ...