Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Combining queries in data set.
Migrateduser
Hi all,
In a dataset I need to call a stored procedure before
sql select query.
First I need to call a stored procedure, that insert ids in a temporary table
And after I need to execute a select query that needs to read ids from
the temporary table.
Is it possible to call the stored procedure and the select query in the same data set ?
or do I need to join two data sets ?
I spent some time on this,
and the only solution I've found was
to write a stored procedure that call the first stored procedure
and the select query. That stored procedure
is used in the dataset.
But I need to defined select query in birt dataset, instead of
writing a stored procedure every time.
Any ideas to call a stored procedure and a select query, both with parameters ?
Thanks in advance.
Find more posts tagged with
Comments
There are no comments yet