NAH, Dapet deehhh..............
Ada nih lebih singkat
pakein aja syntax .......
ASC or DECS next 10 ... dstnya
ambil data/recordset itu dengan "Select .... Next 10 ASC atawa DESC
gampang kan..???
On 10/11/05, Asral Sukma <[EMAIL PROTECTED]> wrote:
Salam buat semua..
kalau saya biasa gunain sp nya sql,jadi di sp nya
pakein kondisi aja,setelah itu sp nya di panggil lewat
cr or vb..
misalnya
create sp.......
as..
select ..........
case nilai..
when .....
then..
end ranking
from.....
semoga membantu..mungkin tmen2 yg lain punya cara
lebih manjur...hehehe
--aL--
--- skdmdn <[EMAIL PROTECTED]> wrote:
> Rekans pakar VB,
>
> Saya membuat tabel seperti ini:
>
> no_induk nilai
>
> 001 43
> 002 32
> 003 75
> 004 66
> 005 90
>
>
> kemudian saya menginginkan report seperti di bawah
> ini:
>
> no_induk nilai ranking
>
> 001 43 4
> 002 32 5
> 003 75 2
> 004 66 3
> 005 90 1
>
> Pertanyaan saya, bagaimana cara membuat report di
> atas dengan menggunakan CR?
>
> Terima kasih atas bantuannya.
> Rijal
>
>
>
__________________________________
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/k7folB/TM
--------------------------------------------------------------------~->
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
--
Senior Instruktur / Programmer
Irazedia Computer and Business Center
Jalan Raya Galaxy Blok A No; 28
Kalimalang - Bekasi Selatan
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
