Database

SELECT
    STUFF(
        (SELECT '/' + Surname + ',' + STUFF(
            (SELECT '-' + Forename 
            FROM YourTable As T2 
            WHERE T2.Surname = T1.Surname 
            ORDER BY T2.Forename 
            FOR XML PATH(''), TYPE
        ).value('.', 'varchar(max)')
        , 1, 1, '')
        FROM YourTable As T1
        
        -- Filter here:
        WHERE T1.ID = @TheIDToFind
        
        GROUP BY Surname
        ORDER BY Surname
        FOR XML PATH(''), TYPE
    ).value('.', 'varchar(max)')
    , 1, 1, '') As CombinedNames
;

DECLARE @T TABLE
(
	ID int NOT NULL,
	Surname varchar(10) NOT NULL,
	Forename varchar(10) NOT NULL
);

INSERT INTO @T (ID, Surname, Forename)
VALUES
	(7, 'Vaugh', 'William'),
	(7, 'Vaugh', 'Smith'),
	(6, 'Woods', 'Jane'),
	(6, 'Woods', 'Joseph'),
	(6, 'Wright', 'Adam'),
	(6, 'Wright', 'John')
;

SELECT
    STUFF(
        (SELECT '/' + Surname + ',' + STUFF(
            (SELECT '-' + Forename 
            FROM @T As T2 
            WHERE T2.Surname = T1.Surname 
            ORDER BY T2.Forename 
            FOR XML PATH(''), TYPE
        ).value('.', 'varchar(max)')
        , 1, 1, '')
        FROM @T As T1
		WHERE T1.ID = 6
        GROUP BY Surname
        ORDER BY Surname
        FOR XML PATH(''), TYPE
    ).value('.', 'varchar(max)')
    , 1, 1, '') As CombinedNames
;

-- Output:
-- Woods,Jane-Joseph/Wright,Adam-John

Chaminda Aruna Bandara wrote:

as a Senior Technical Support Analyst

id	int 
operation nvarchar(50)
table_name nvarchar(200)
col_name nvarchar(200)
key_col nvarchar(200)
key_val nvarchar(200)
col_val_prior nvarchar(MAX)
col_val_new nvarchar(MAX)
username nvarchar(50)
transaction_dt datetime
batch nvarchar(MAX)

1. Get the records from your database, using a SELECT clause.
2. Save that response into a variable of type array (or a generic list).

public void GetDatainArr()
{
        string strSQl = "";
        string[] Arr = new string[50];
        strSQl = "select [Id] from [tblname] ";
        DataTable dt = GetDataTable(strSQl); //GetDataTable function 
        if (dt.Rows.Count > 0)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Arr[i] = Convert.ToString(dt.Rows[i][0]);
            }
        }
}
public DataTable GetDataTable(string Sql)
{
        SqlConnection conn = new SqlConnection("ConnectionString ");
        conn.Open();
        DataTable dt = new DataTable();
        SqlCommand cmd = new SqlCommand(Sql, conn);
        SqlDataAdapter ad = new SqlDataAdapter();
        ad.Fill(dt);
        conn.Close();
        return dt;
}