name family a b c d e f
<pre lang="HTML"> fullname ab,cd,ef </pre>
INSERT @Temp SELECT FTeacherName + ' ' + FTeacherFamily FROM [dbo].[VDB_Teacher] WHERE FCourseExeID=@idcoursexe RETURN
DECLARE @teachers varchar(MAX) SET @teachers = '' SELECT @teachers = @teachers + RTRIM(FTeacherName) + ' ' + RTRIM(FTeacherFamily) FROM [dbo].[VDB_Teacher] WHERE FCouseExeID=@idcourseexe --Remove the last comma SELECT LEFT(@teachers , LEN(@teachers ) - 1)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)