In Oracle it's a structure

but after i migrate from oracle to sqlserver it come a like u see it

i do the migrate with swiss its a soft

so...

it's just a variable and not a table

this the definition of card data which usedd the function :

CREATE TABLE Card_data (

Card_number VARCHAR(24) NOT NULL AUTO_INCREMENT,

Bank-code CHAR(5) NOT NULL,

Branch-code CHAR(5) NOT NULL,

...

v_accounts_info_table is just a varchar

i use this for develloping my final project

and the function is develloped for card data table

the loop is made to fill the sequence each time it reaches the threshold

this is the implementation on oracle :

FUNCTION NEW_GET_CARD_ACCOUNT( p_card_accounts IN ...

sur i want ur help

so what i have to do to have it

Sure i want your help

what i have to do ??

i give the function & the table

apres avoir consulté de certain cour j'ai pu arrivé a realiser cette fonction sa me genere une erreur (Msg 443, Level 16, State 15, Procedure NEW_GET_CARD_ACCOUNT, Line 59

Invalid use...

Finally i had this function so plz if u could correct :

CREATE FUNCTION NEW_GET_CARD_ACCOUNT(

@p_Accounts_list varchar(20),

...

this what is come after modification :

CREATE FUNCTION NEW_GET_CARD_ACCOUNT(

@p_Accounts_list varchar(20),

...

oki I agree trying to move the function from oracle to sqlserver

if ever there has the help and ideas not hesitate

that's what i m trying to do

if u have any idea

u welcome