Friday, September 26, 2003, 6:36:08 AM, you wrote: Mas Yadi, thanks atas sarannya, tapi cara spt ini sangattttt memakan resource, cara spt ini pernah diposting entah tahun berapa sama mas sugi, waktu itu dia pake email @bigfoot.com (waktu bigfoot.com masih nggak mbatesin posting) inget nggak mas sugi... :)
Ini pake nested-select, misal kalo kita punya record sebanyak 100 maka sql akan menscan/menyeleksi row sebanyak 100*99 + 99*98 + 98*97 + 97*96 dst... CMIIW, bayangin cuman mau nyari 100 record masa harus scan sebanyak itu?? AY> maaf diralat :P AY> @NSkip harus nya terpakai dalam SP AY> create proc SP_Select_Skip(@NamaTable as varchar(255),@SFieldKey as AY> varchar(255),@NFirst as bigint, @NSkip as bigInt) AY> as AY> declare @Ssql as varchar(8000) AY> set @ssql='select top '+cast(@nfirst as varchar(20))+' * from '[EMAIL PROTECTED] AY> +' where '[EMAIL PROTECTED]' not in ( select top '+cast( @NSkip as AY> varchar(20)) AY> +' '[EMAIL PROTECTED] AY> +' from '[EMAIL PROTECTED] ' order by '[EMAIL PROTECTED]' ) order by AY> '[EMAIL PROTECTED] AY> exec( @ssql) AY> go AY> BR, AY> Ahmad Yadi <!--DEL--> --- Best regards, Syarif Lumintarjo [EMAIL PROTECTED] ------------------------ 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/
