In table records as follows
TTDate Course Sess Topic Staff
Aug2 Eng 1 Rev Mj
Aug2 Tam 2 Maj Mj
Aug2 Mat 3 Tom Mj
From my above table i want output as follows
Dear Mj, Aug2(Eng -Rev/1,Tam -Maj/2,Mat -Tom/3)
For that i written a stored procedure as follows
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[OH_TimeTable]
as
DECLARE @MyString VARCHAR(MAX)
SET @MyString = ''
SELECT @MyString = COALESCE(@MyString + ',', ' ') +[TTDate] + [Course] + [Sess] +[Topic]
from Tb_Sch_Time_Table where Active <> 'D'
SELECT @MyString as MyString
When i execute the stored procedure output as follows
,Aug2 Eng 1 Rev,Aug2 Tam 2 Maj,Aug2 Mat 3 Tom
But i want the stored procedure output as follows
Dear Mj, Aug2(Eng -Rev/1,Tam -Maj/2,Mat -Tom/3)
please help me from my above stored procedure. what is the mistake i made.