Information générale
Forum:
Microsoft SQL Server
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement