I want to access the id of a particular name by using sql query. ie inside execute query activity, I use the query as : “select id from employee where name=‘aaa’”. by using this query I get the result. But when I need to access the id of a person whose name is stored in string variable.
ie name = “aaa”
now I need to write query whith variable name.How to write the query anyone please help me?