DECLARE @str VARCHAR(100)
(SELECT @str = COALESCE(@str + '', '') + CONVERT(VARCHAR, [WINDOW_START]) FROM ANC_IND_HIST)
DECLARE @dates VARCHAR(50)
select TOP 100
[INDIVIDUALS 2].IND_ID,
[INDIVIDUALS 2].Ind_Full_Name,
(select anc_ind_hist.window_start) AS plan_window_start,
(SELECT @str = COALESCE(@str , '') + CONVERT(VARCHAR, [WINDOW_START]) FROM ANC_IND_HIST)
/*(SELECT @str = COALESCE(@str + '', '') + [WINDOW_START]) as windows_start */
FROM [individuals 2]
LEFT JOIN ANC_IND ON ([individuals 2].IND_ID = ANC_IND.IND_ID)
LEFT JOIN ANC_IND_PLAN ON (ANC_IND.IND_ID = ANC_IND_PLAN.IND_ID)
LEFT JOIN ANC_IND_HIST ON (ANC_IND.IND_ID = ANC_IND_HIST.IND_ID)