$query = "exec myProcedure";

$query = "exec myProcedure"; // собственно вызываю процедуру
    $result = mssql_query($query);
        while ($row = mssql_fetch_assoc($result)) { //получаю массив значений из хранимки, но он пустой.
        print $row['kustId'];
        }

USE [dev]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[tm_reportErrorModules]

AS
BEGIN

	SET NOCOUNT ON;
	
DECLARE @kpRowId int
DECLARE @devTypecapt nvarchar(50)
DECLARE @devName nvarchar(50)
DECLARE @objId int
DECLARE @objCapt nvarchar(50)
DECLARE @devId int
	
CREATE TABLE #Result
(
	kustId int,
	kustName nvarchar(50),
	kpId int,
	kpType nvarchar(50),
	kpName nvarchar(50),
	moduleNum int,
	answer nvarchar(50),
	datePoint datetime
) 

INSERT INTO #Result(kpId, moduleNum, answer, datePoint) SELECT dev_id, module_num, link_msg, datepoint FROM kp_modules_state

DECLARE kpRow CURSOR LOCAL FORWARD_ONLY READ_ONLY
FOR SELECT kpId FROM #Result
OPEN kpRow
FETCH NEXT FROM kpRow INTO @kpRowId

WHILE @@FETCH_STATUS = 0
BEGIN

	DECLARE upOne CURSOR LOCAL FORWARD_ONLY READ_ONLY
	FOR SELECT kd.obj_id, kdt.dev_type_capt, kd.dev_name, do.capt kustCapt, kd.dev_id FROM kep_dev kd, kep_dev_type kdt, d_obj do WHERE kd.dev_type_id = kdt.dev_type_id and do.obj_id = kd.obj_id and kd.dev_id = @kpRowId
	OPEN upOne
	FETCH NEXT FROM upOne INTO @objId, @devTypecapt, @devName, @objCapt, @devId
	WHILE @@FETCH_STATUS = 0
	BEGIN
	UPDATE #Result SET kustId = @objId,kustName = @objCapt, kpName = @devName, kpType = @devTypecapt WHERE kpId = @devId
	FETCH NEXT FROM upOne INTO @objId, @devTypecapt, @devName, @objCapt, @devId
	END
	CLOSE upOne
	DEALLOCATE upOne 


FETCH NEXT FROM kpRow INTO @kpRowId
END 
CLOSE kpRow
DEALLOCATE kpRow

SELECT kustId, kustName, kpId, kpType, kpName, moduleNum, answer, datePoint FROM #Result

END

$stmt=mssql_init("reportProcedure", $conn);
/* execute the procedure */
$result = mssql_execute($stmt);

/* get the row that is returned */
$row = mssql_fetch_assoc($result);

/* get my value out */
$my_id = $row['album_id'];

$link = mssql_connect('127.0.0.1', 'user', 'pass');
mssql_select_db('dev');
$stmt=mssql_init("reportProcedure", $link);
$result = mssql_execute($stmt);
$row = mssql_fetch_assoc($result);
$my_id = $row['idParam'];
echo $my_id;

function &get_conn()
{
   global $conn;
   $myServer = "127.0.0.1";
   $myUser   = "user";
   $myPass   = "pass";
   $myDB     = "dev"; 

   if(!$conn)
   {
      $conn = mssql_connect($myServer, $myUser, $myPass)
         or die("Couldn't connect to SQL Server on $myServer");
      mssql_select_db($myDB, $conn)
         or die("Couldn't select database $myDB");
   }
   return $conn;
}
$conn =& get_conn();
$stmt=mssql_init("reportProcedure", $conn);
$result = mssql_execute($stmt);
$row = mssql_fetch_assoc($result);
$my_id = $row['idParam'];
echo $my_id;

CREATE TABLE #ResultUI
(
	[kustId] [int] NULL,
	[kustName] [nvarchar] (50) NULL,
	[kpId] [int] NULL,
	[kpType] [nvarchar] (50) NULL,
	[kpName] [nvarchar] (50) NULL,
	[moduleNum] [int] NULL,
	[answer] [nvarchar] (50) NULL,
	[datePoint] [datetime] NULL
)