Menzk

I have a sp which has multiple resultset.I need to create another procedure which should execute the second resultset of 1st sp for ex SP1 gives two resultset I need to write sp2 which uses only the second resulset

I have a sp which has multiple resultset.I need to create another procedure which should execute the second resultset of 1st sp for ex SP1 gives two resultset I need to write sp2 which uses only the second resulset

I have a sp in mssql which gives multiple resultsets.I need to display the result in html table using php . I am using mssql_fetch_assoc() & mssql_next_result(). How to store each resultset in a array and retrieve it. $result=student_sp('1231','1') do curlybrace while($row=mssql_fetch_assoc($result)) brace $name=$row[name]; $age=$row[age]; $marks=$row[marks]; $term=$row[terms]; $Subject=$row[sub]; $html="<table><tr><td>$name</td></tr><tr><td>$age</td></tr></table>" $mark="<table><tr><td>$subject</td></tr><tr><td>$marks</td></tr></table …

can we able to count how many number of resultset is returned by a stored procedure? i have a sp which will result in multipe resultset. more then 6.sometime 4 sometime 6 based on the parameters. so i need to count how many resultsets are returned by the sp