Hello,
Kalo Scriptnya seperti ini bagaimana ?
----------------------------------------------------
CREATE PROCEDURE sp_PosisiStrategis
@posisi integer, @jumlah_output integer
AS
-- @ix sebagai counter
declare @ix integer
set @ix = 0
declare authors_cursor SCROLL cursor for
SELECT * from authors
open authors_cursor
FETCH ABSOLUTE @posisi FROM authors_cursor
WHILE (@@FETCH_STATUS = 0) AND (@ix < @jumlah_output)
BEGIN
set @ix = @ix + 1
-- This is executed as long as the previous fetch succeeds.
FETCH NEXT FROM authors_cursor
END
CLOSE authors_cursor
DEALLOCATE authors_cursor
GO
----------------------------------------------------
note:
result masih dalam terpecah2 dan masih perlu disatukan dalam satu
result set yang baik. mungkin array ?
mohon komentarnya.
--
Regards,
Tim
a Rookie
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Upgrade to 128-Bit SSL Security!
http://us.click.yahoo.com/p7cEmB/s7qGAA/yigFAA/i7folB/TM
---------------------------------------------------------------------~->
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
