accessing values of mssql stored procedures

[eluser]bhakti.thakkar[/eluser]
hi all,
i have an mssql stored procedure which will always return one single recordset. How will will access the values of the SP
below is code in the Controller file:

Code:

function PreviewCertificate($TransactionCertificate_ID) {
        $data['TransactionCertificate_ID'] = $TransactionCertificate_ID;
        $data['pgdata'] = $this->db->query("Exec up_parmsel_rpt_TempTransactionCertificate @TransactionCertificate_ID='$TransactionCertificate_ID' , @Company_ID='1' ");


        $this->load->view('certificates/PreviewCertificate' , $data);

    }

now in the view page how can i access the values of pgdata?

if i do : print($pgdata->TransactionCertificate_ID);
it gives me an error : Undefined property: CI_DB_mssql_result::

How can i access the values in the Stored Procedure
Thanks