Loading

how do i get values from multiple cells into one cell

how do i get values from multiple cells into one cell

Nepethya Rana

9y864

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 2,First agenda.
4	1	2	This Is day 2 , Second agenda.
5	1	2	This Is day 2, Third agenda.

How do i achieve this?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nepethya Rana9y ago
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)')
,1,1,'')
FROM tblAgenda a1
GROUP BY MeetingID having MeetingID=@MeetingID;

RETURN @Agenda;
END;
0
Zakir Ahamed9y ago
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(Id,AgendaId,Agenda)
values (1,1,'This Is day 1, First agenda.') ;

then You need to get all ID Based the data from the table agenda automatically
0