ajaybelde
asked on
may be stored procedure.
I Have Table T1(A,B,C) and I have a Table t2(D,E,F).
when ever i want to insert on table t1 in coulmn A,B,C. I want to insert it into table T2 same value for clumns in T1 + may be appending some additional value to table t2 or .
what would be the best approach and can i sample code for it.
for ex:
if insert (USA,UK,IND) in to T1 i need to pass values and append 001 for USA and 044 to uk and 091 to IND and it should insert like (USA001,UK044,IND091).
in above example 001,044,091 should be any value i want to append it to the value in table T1.
when ever i want to insert on table t1 in coulmn A,B,C. I want to insert it into table T2 same value for clumns in T1 + may be appending some additional value to table t2 or .
what would be the best approach and can i sample code for it.
for ex:
if insert (USA,UK,IND) in to T1 i need to pass values and append 001 for USA and 044 to uk and 091 to IND and it should insert like (USA001,UK044,IND091).
in above example 001,044,091 should be any value i want to append it to the value in table T1.
ASKER
its manual
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@sdstuber
does p_a ,p_b,p_c is also need to be passed Manual?.
my req is whenver we insert p_a ,p_b,p_c on t1(which is not manual) it should insert VALUES in t2 (p_a || p_d, p_b || p_e, p_c || p_f) and i should able pass the values p_d, p_e, p_f manually where ever required
does p_a ,p_b,p_c is also need to be passed Manual?.
my req is whenver we insert p_a ,p_b,p_c on t1(which is not manual) it should insert VALUES in t2 (p_a || p_d, p_b || p_e, p_c || p_f) and i should able pass the values p_d, p_e, p_f manually where ever required
if a non manual process inserts a,b,c to t1
how do you imagine a user could possibly be prompted to manually enter d,e,f?
The request doesn't make sense to me.
how do you imagine a user could possibly be prompted to manually enter d,e,f?
The request doesn't make sense to me.
ASKER
if it is manual for all values. how would i pass 6 values to SP
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What does the appended value do? From your example, it looks like it could be a numerical representation of the country code. That would mean for every value in T1, there would be a corresponding append value, which could be managed by a lookup table of some sort. If that's not the case and the values that get appended are truly random or at the mercy of someone's imagination, what good do they do? If there is some sort of criteria that define the values to be appended, I think you might still accomplish your intent with an after insert trigger that applies the criteria logic.
ASKER
they are planning to prevent it from application logic
Where are you getting the values to append?
I don't see how a stored procedure would work unless you have some 'new' flag in t1 that the procedure can process in batch mode.