maaf diralat :P
@NSkip harus nya terpakai dalam SP
create proc SP_Select_Skip(@NamaTable as varchar(255),@SFieldKey as
varchar(255),@NFirst as bigint, @NSkip as bigInt)
as
declare @Ssql as varchar(8000)
set @ssql='select top '+cast(@nfirst as varchar(20))+' * from '[EMAIL PROTECTED]
+' where '[EMAIL PROTECTED]' not in ( select top '+cast( @NSkip as
varchar(20))
+' '[EMAIL PROTECTED]
+' from '[EMAIL PROTECTED] ' order by '[EMAIL PROTECTED]' ) order by
'[EMAIL PROTECTED]
exec( @ssql)
go
BR,
Ahmad Yadi
[Non-text portions of this message have been removed]
------------------------ 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/
