Post reply

Do SSRS dataset supports two result set?

  • June 10, 2008 at 1:44 am

    #192067

    Hi,

    My stored procedure returns two result set.Do SSRS dataset supports two result sets?when i put join on the two result sets am getting single but it takes 15 mints and more to see the result.How can i solve this issue

    Thanks in advance

    Dimple

  • June 11, 2008 at 3:32 am

    #827126

    No, only a single data set is supported.

  • June 12, 2008 at 7:24 am

    #827831

    Dimple,

    If you can modify the proc to use temp tables, this tactic may help you:

    create proc test2

    as

    begin

    insert into #x

    select getdate() as date1

    insert into #y

    select datepart(hour,getdate()) as hour1, datepart(minute,getdate()) as minute1

    end

    create proc wrapper

    as

    begin

    create table #x ( date1 smalldatetime )

    create table #y ( hour1 tinyint, minute1 tinyint )

    exec test2

    select * from #x cross join #y

    drop table #x

    drop table #y

    end

    In the wrapper proc, create an index on one of the tables to assist in the join.

  • June 12, 2008 at 8:00 am

    #827872

    Hi,

    Thanks for your response!!

    Am not supposed to you two procedures for this requirement.Need to accomplish in the same itself.Also the records returned when i put cross join is around more than 10 lacs.So it hits performance also.Then one more thing is i tried the example you given already in one sp itself.Result not satisfactory.

    Thanks

    Dimple

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply