Yeap, I'm still having some issues: Incorrect syntax near 'application_detet'.
Code:
DECLARE @sql varchar(255)
SELECT @sql = 'SELECT candidate_last_name, candidate_first_name... ' +
'FROM vw_applicationDetail ' +
'WHERE application_status_id = ' + CAST(@statusCode As varchar(10) + ' ' +
'AND current_status_ind = ' + CAST(@currentStatus As varchar(10)) + ' '
'AND application_deleted_ind = 0 ' + What is your advise, oh wizardess of SQL?
Your Lord and Master,
JMH
