I want to set up a label to update dynamically..I can use either a Case Statement or an IFF, But I am not sure exactly how to do it..
for the Project, I have 4 employees, Mary, Tom, Pete, Gordon,,HOW do I set the query that when Mary is selected, it updates that Mary is Female, Pete is Male and so forth.
or any good Links I can follow.
Thanks in advance.
not sure what you mean by "set up a label". Also not sure if you want to do this in SSIS or SQL. Could you please clarify and also post your table definition and some sample data?