Here is the code for creating Temp. Table.

SET @vch_WhereString = 'SELECT cdt_num_RegistrationId, cdt_num_cdtID, cdt_int_CategoryId, cdt_int_JobId,
RTRIM(cdt_vch_FirstName) + SPACE(1) + RTRIM(cdt_vch_MiddleName) + SPACE(1) + RTRIM(cdt_vch_LastName) AS Name,
cdt_vch_Email, cdt_vch_Password, SPACE(500) AS SKILLS
INTO #tmp_Candidates FROM Candidates ' + @vch_WhereString

EXEC(@vch_WhereString)

SKILLS is the dummy column with SPACE(500). Which I need to update from Candidate's child table called SKILLS. In SKILLS table I have multiple skills for each candidate. Using all child records I need to build string and update back to #tmp_Candidates table for perticular candidate. Is it possible?

Thanks,

Ravi