;
WITH
	kodebi_all AS
	(
	SELECT		id_patient_history, 
				top_test_mini
	FROM		top_test TP
				RIGHT JOIN baza B
					ON TP.id_top_test = B.id_top_test
	) 
UPDATE	PSD
SET		kodebi = kodebi+', ' +top_test_mini
FROM	#Personaldate PSD
		INNER JOIN kodebi_all as K 
		ON PSD.id_patient_history = K.id_patient_history 

[src][SRC sql]CREATE Table #Personaldate 
		(
		momartvis_tarigi Date, 
		visitis_time Date,
		id_patient int,
		id_patient_history int,
		gvarsaxeli nvarchar(200),
		birthday Date,
		SumOffasi money,
		kodebi nvarchar(MAX),
		organization nvarchar(500),
		id_organization int  
		)

;
WITH
	patients_gamokvlevebis_fasebi AS
	(
	SELECT		id_patient_history, 
				Sum(fasi) SumOffasi
	FROM		baza
	GROUP BY	id_patient_history
	)
INSERT INTO #Personaldate 
		(
		id_patient,
		id_patient_history,
		id_organization,
		momartvis_tarigi, 
		visitis_time,
		gvarsaxeli,
		birthday,
		SumOffasi,
		organization
		)
SELECT	P.id_patient,
		PH.id_patient_history,
		PH.id_organization,
		momartvis_tarigi,
		visitis_time,		
		CONCAT(gvari, ' ', saxeli, ' ', mamis_saxeli) gvarsaxeli,
		birthday,
		SumOffasi,
		organization		
FROM	patients P
		RIGHT JOIN patients_history PH
			ON P.id_patient = PH.id_patient
		INNER JOIN patients_gamokvlevebis_fasebi PGF
			ON PH.id_patient_history = PGF.id_patient_history 
		LEFT JOIN organization O
			ON PH.id_organization = O.id_organization 
WHERE	PH.id_organization Is Not Null

;
WITH
	kodebi_all AS
	(
	SELECT		id_patient_history, 
				top_test_mini
	FROM		top_test TP
				RIGHT JOIN baza B
					ON TP.id_top_test = B.id_top_test
	) 
UPDATE	PSD
SET		kodebi = kodebi+', ' +top_test_mini
FROM	#Personaldate PSD
		INNER JOIN kodebi_all as K 
		ON PSD.id_patient_history = K.id_patient_history 

SELECT * FROM #Personaldate

DROP Table #Personaldate 

SET kodebi = CONCAT(kodebi,', ',top_test_mini) 

IF
	OBJECT_ID('tempdb..#Personaldate')
IS NOT NULL
	DROP Table #Personaldate 

 IF
	OBJECT_ID('tempdb..#Personaldate') IS NOT NULL
	DROP Table #Personaldate 

 CREATE TABLE #Personaldate  (ID INT)

select concat(distinct top_test_mini) as names, id_patient_history
    from kodebi_all
    group by id_patient_history

DECLARE @v varchar(max);

WITH kodebi_all AS
()
SELECT @v = concat(@v, ', ' ,top_test_mini)
FROM ... ;

SELECT @v = stuff(@v,1,2,'');

;
WITH
	kodebi_all AS
	(
	SELECT		id_patient_history, 
			top_test_mini
	FROM		top_test TP
			RIGHT JOIN baza B
				ON TP.id_top_test = B.id_top_test
	) 
SELECT		id_patient_history,
		kodebi = replace((select cast(top_test_mini as nvarchar) as 'data()' from kodebi_all where id_patient_history = t.id_patient_history for xml path('')), ' ', ', ')
FROM		kodebi_all t
GROUP BY	id_patient_history

CONCAT(top_test_mini, '|') minitest

;
WITH
	kodebi_all AS
	(
	SELECT		id_patient_history, 
				CONCAT(top_test_mini, '|') minitest
	FROM		top_test TP
				RIGHT JOIN baza B
					ON TP.id_top_test = B.id_top_test
	), 
	kodebi_all_sruli AS
	(
	SELECT		id_patient_history,
				KDO = replace((select cast(minitest as nvarchar) as 'data()' from kodebi_all where id_patient_history = t.id_patient_history for xml path('')), '|', (', '))
	FROM		kodebi_all t
	GROUP BY	id_patient_history
	),
	patients_gamokvlevebis_fasebi AS
	(
	SELECT		id_patient_history, 
				Sum(fasi) SumOffasi
	FROM		baza
	GROUP BY	id_patient_history
	)
SELECT	P.id_patient,
		PH.id_patient_history,
		PH.id_organization,
		momartvis_tarigi,
		visitis_time,		
		CONCAT(gvari, ' ', saxeli, ' ', mamis_saxeli) gvarsaxeli,
		birthday,
		KDO,
		SumOffasi,
		organization		
FROM	patients P
		RIGHT JOIN patients_history PH
			ON P.id_patient = PH.id_patient
		INNER JOIN patients_gamokvlevebis_fasebi PGF
			ON PH.id_patient_history = PGF.id_patient_history 
		LEFT JOIN organization O
			ON PH.id_organization = O.id_organization 
		INNER JOIN kodebi_all_sruli as K 
			ON PH.id_patient_history = K.id_patient_history