Stored Procedure Return value

Dear all, please help again.
I create stored procedure like this:
-----------------
CREATE PROCEDURE sp_test AS
select * from employee
GO
-----------------

and when I call from ASP:
rsconn.recordcount
its return--> 2546

But why if I create stored procedure like this:
-----------------------
CREATE PROCEDURE sp_test AS
DECLARE @result TABLE(apl_group varchar(2), total float, aver float, grade int, account int)
.... some code....
select * from @result
GO
-------------------------
Its always return---> -1

How to solved this problem?
Please help me.

Regards,


e2rd

recordcount will fail in many cases. Look at the ADO recordset documentation, MS has a fairly detailed explanation of how and when recordcount may not work.

E2rd,
Recordcount return -1 means that the number of records contained can't be determined.
bisa liat contoh sp kamu?


Regards

Tonny

Dear pak Tonny Soeroso,
Here is my sp example.

regards,

e2rd


CREATE PROCEDURE sp_r_sales_structure
AS
DECLARE @table TABLE(REGION VARCHAR(30), NPK_DIAMOND VARCHAR(10), NAMA_DIAMOND NVARCHAR(255),
NPK_GOLD VARCHAR(10), UPLINE_GOLD VARCHAR(10), NAMA_GOLD NVARCHAR(255),
NPK_SILVER VARCHAR(10), UPLINE_SILVER VARCHAR(10), NAMA_SILVER NVARCHAR(255)
)
DECLARE @REGION VARCHAR(30), @NPK_DIAMOND VARCHAR(10), @NAMA_DIAMOND NVARCHAR(255),
@NPK_GOLD VARCHAR(10), @UPLINE_GOLD VARCHAR(10), @NAMA_GOLD NVARCHAR(255),
@NPK_SILVER VARCHAR(10), @UPLINE_SILVER VARCHAR(10), @NAMA_SILVER NVARCHAR(255)
DECLARE edo_cursor CURSOR FOR
SELECT b.region, e.npk as NPK_DIAMOND, e.nama as NAMA_DIAMOND,
e1.npk as NPK_GOLD, e1.upline AS UPLINE_GOLD, e1.nama AS NAMA_GOLD,
e2.npk AS NPK_SILVER, e2.upline AS UPLINE_SILVER, e2.nama AS NAMA_SILVER
FROM employee e
INNER JOIN employee e1 ON e.npk=e1.upline AND e1.sales_level='02'
INNER JOIN employee e2 ON (e1.npk=e2.upline OR e.npk=e2.upline) AND e2.sales_level='03'
INNER JOIN branch b ON b.rc=e.branch_code
WHERE e.sales_level='01'
ORDER BY NPK_DIAMOND, UPLINE_GOLD, UPLINE_SILVER

OPEN edo_cursor
FETCH NEXT FROM edo_cursor INTO @REGION, @NPK_DIAMOND,@NAMA_DIAMOND, @NPK_GOLD, @UPLINE_GOLD, @NAMA_GOLD, @NPK_SILVER, @UPLINE_SILVER, @NAMA_SILVER
WHILE @@FETCH_STATUS = 0
BEGIN
IF @UPLINE_SILVER = @UPLINE_GOLD
BEGIN
SET @NPK_GOLD=@NPK_DIAMOND
SET @NAMA_GOLD=@NAMA_DIAMOND
END
INSERT @table VALUES (@REGION, @NPK_DIAMOND,@NAMA_DIAMOND, @NPK_GOLD, @UPLINE_GOLD, @NAMA_GOLD, @NPK_SILVER, @UPLINE_SILVER, @NAMA_SILVER)
FETCH NEXT FROM edo_cursor INTO @REGION, @NPK_DIAMOND,@NAMA_DIAMOND, @NPK_GOLD, @UPLINE_GOLD, @NAMA_GOLD, @NPK_SILVER, @UPLINE_SILVER, @NAMA_SILVER
END

CLOSE edo_cursor
DEALLOCATE edo_cursor
select distinct * from @table