I have a stored procedure that accepts parameters and doing some calculations, will return a resultset. I've tried to use a) Table Variables b) Temp tables and neither one seems to work. If I do a select top 0 * from
, than the fields will show up but the powerpivot won't return the record set. I had it place as such:
begin of procedure
select top 0 * from
/*
do calculation with another table via joins
*/
select * from
end procedure
begin of procedure
select top 0 * from
/*
do calculation with another table via joins
*/
select * from
end procedure
