From here, here's an example: 1. Create the UDF CREATE FUNCTION CombineValues ( @F_ID INT --The foreign key from TableA which is used to fetch corresponding records ) RETURNS VARCHAR(8000) AS BEGIN DECLARE @SomeColumnList VARCHAR(8000); SELECT @SomeColumnList = COALESCE(@SomeColumnList + ', ', '') + CAST(SomeColumn AS varchar(20)) FROM TableB C WHERE C. FK_ID = @FK_ID; RETURN ( SELECT @SomeColumnList ) END 2.
Use in subquery SELECT ID, Name, dbo. CombineValues(FK_ID) FROM TableA.
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.