I'm always fascinated by interviewers that think something needs to be done in a single SQL statement and I'm just as fascinated by interviewers that think you should generate such code from the application. So far as I'm concerned, the correct answer should be...
EXEC dbname.schemaname.storeprocedurename(list of parameters)
--Jeff Moden
Change is inevitable... Change for the better is not.