var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Using Columns from a Stored Procedure
How can I use certain column from my stored procedure? I have written the below code but doesnt work
SELECT * FROM exec spSalesPipeline @ConsultantName = 'Bob Smith'
You should really use a view or function instead of a sproc if you want to use one like this.
Otherwise there are two work arounds I know of:
1) Create a table that matches the output and insert in to that.
2) Use OPENROWSET
Both though are not preferred to correcting the design