December 7, 2011 at 8:45 pm
Hi ALL,
I in need of getting three different types of data and showing them in a ssrs report grouped by location.
In my stored procedure I am using 3 table variables to hold these different types of data and then in the final output I am using a full outer join between these 3 tables to get different data in one row and grouping them by location. I am getting the result set as expected but I was wondering is there any other way I can achieve this without using a full outer join?
Also, in this stored procedure I am already calling another stored procedure which already is making it little slow.I am concerned that if the data grows very large then the stored procedure might get slow due to a full outer join? What should be a good approach?
December 8, 2011 at 12:13 am
If you post your stored procedure code, DDL & sample data many guys here would be able to help you.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply