how do i get values from multiple cells into one cell

Question

how do i get values from multiple cells for a column into one cell of another table. I have tblAgenda and tblMeeting. I want to have all agenda notes from Agenda Daily Note column of tblAgenda into Agenda Column which needs to be computed column on tblMeeting. tblMeeting ID Agenda 1 tblAgenda AgendaID MeetingID Day Agenda daiy Note 1 1 1 This Is day 1 First agenda. 2 1 1 This Is day 1 Second agenda. 3 1 2 This Is day 2First agenda. 4 1 2 This Is day 2  Second agenda. 5 1 2 This Is day 2 Third agenda. How do i achieve this?

Nepethya Rana · Answer

I create this function. This works in my requirement. Create [dbo].[ufnGetAgenda](@MeetingID int) RETURNS varchar(max) AS -- Returns the stock level for the product. BEGIN DECLARE @Agenda varchar(max); SELECT @Agenda =stuff( (SELECT ''+ [Agenda daiy Note] FROM tblAgenda a2 WHERE a2.MeetingID = a1.MeetingID FOR XML PATH('') TYPE).value('.' 'varchar(max)') 11'') FROM tblAgenda a1 GROUP BY MeetingID having MeetingID=@MeetingID; RETURN @Agenda; END;

Zakir Ahamed · Answer

hi Just set the tblAgendaId -> AgendaID as a foreign key to tblMeeting ->ID make a relationship Add one more column in tblMeeting as a AgendaId then Write a Storeprocedure: insert into tblMeeting(IdAgendaIdAgenda) values (11'This Is day 1 First agenda.') ; then You need to get all ID Based the data from the table agenda automatically

tblMeeting
ID	Agenda
1

tblAgenda
AgendaID	MeetingID	Day	Agenda daiy Note
1	1	1	This Is day 1, First agenda.
2	1	1	This Is day 1, Second agenda.
3	1	2	This Is day 2,First agenda.
4	1	2	This Is day 2 , Second agenda.
5	1	2	This Is day 2, Third agenda.