Comments by ktrrzn (Top 2 by date)

ktrrzn 22-Mar-11 19:49pm View

the old insert sp accept 7 parameters and some of them are depend on the XML input parameter of new sp.
Like: grade, skilllevel, result. these will be passed from my new sp to old sp to insert the new record.
the xml will contain info of many participants.
For my new sp, i can handle this XML format for multiple update process.
But for old one, it is designed only for one insert
So, I m thinking whether i copy all the insert process from old one and combine with my new sp
to do all the thing.
But I'm not sure this is a good way.
Could u plz guide me on this..

Thank you

ktrrzn 22-Mar-11 0:23am View

Hi walterhevedeich,

How can I do this TRIGGER? In which table? in new table or in existing table?
I'm not sure but TRIGGER don't accept parameter input, right?
I need to pass parameters to execute my existing stored proc..

Thank you