View Full Version : results are not retrieved if temp tables are used in stored procedure not

04-30-2009, 09:11 AM
Dear All
I have created a stored procedure which first creates an temporary table, insert the values and queries it. This works perfectly in MSSQL management studio, but when i try to execute the same procedure using php, it does not returns any rows.

I am using PEAR DB and MSSQL 2005

$sql="Exec up_parmsel_inspectionreportstatus_dashboard";
$data_arr = $db->getAll($sql, DB_FETCHMODE_ASSOC);
print_r ($data_arr);

Whats going wrong?


05-02-2009, 06:36 AM
Please help me out. or suggest a different solution.