ok thanx a lot for that clue it works...

thanx before..

the problem i faced is query for distribute 3 id_support to handle amount of id_cust where thats distribute incremental based on id_support...

the source and the result will like that...

HI ALL,

i just try to solve my problem..but it can't run..

this my code trial :

CREATE PROCEDURE SP_TRY

@ID_DATEL numeric

AS

DECLARE

@ID_PELANGGAN AS NUMERIC,

...