mainrotor
asked on
I need help running this stored proc from this query syntax.
I get an error when I try to run the following SQL Syntax:
with tbla as
(
EXEC [sp_InventoryETA]
)
select * from tbla
with tbla as
(
EXEC [sp_InventoryETA]
)
select * from tbla
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
without knowledge of what the SP does, and what you want to achieve, we are guessing.
What that SP returns?
ASKER
Vitor,
The SP returns a list of records for products and their ETAs.
The SP returns a list of records for products and their ETAs.
You have to create a temp table,
1. create temp table.
2 insert into temp table
exec ('exec [sp_InventoryETA]')
3 select * from temp table.