-- Insert statements for procedure here
	SELECT dbo.CSR_DOSSIER.DOS_NOM +' '+  ISNULL ( dbo .CSR_DOSSIER.DOS_PRENOM, ' ') as Nom 
	FROM dbo.CSR_DOSSIER ,dbo.CSR_STATUT 
	WHERE CSR_DOSSIER.DOS_ID = CSR_STATUT.STA_ID
	AND dbo .CSR_DOSSIER.DOS_ID =(SELECT dbo.CSR_DOSSIER.DOS_ID 
									FROM dbo.CSR_DOSSIER WHERE DOS_NODE =@node )
	    
	AND CSR_STATUT.STA_ID=6 OR CSR_STATUT.STA_ID=7

SELECT TABLE_NAME,COLUMN_NAME 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_NAME IN ('CSR_DOSSIER','CSR_STATUT')
AND DATA_TYPE = 'uniqueidentifier'