Team,
I have been tasked with writing a custom procedure that will display and update the constituent gender for both name1 and name2. This procedure will be used via the API calls. Before I venture out I thought I would check and see if anyone has done this before. Does anyone have any stored procedures to do this or tips?
Many thanks!
Naomi
Sorry forgot to add the stored procedure code could look something like the following:
select sex,sex2 from t_customer
join t_web_session_session on t_web_session_session.customer_no=t_customer_no
where
sessionkey=''
Sorry had a typeo in my last response. select
Sorry had a typeo in my last response.
select
sex,sex2 from t_customer
join
t_web_session_session on t_web_session_session.customer_no=t_customer.customer_no