TBL\_EMPLOYEE 

```
ID  NAME        SOURCE
1   SANDERS     OUTSOURCE

```

TBL\_AUDIT

```
NAME    COLUMNNAMES COLUMNVALUES

```

On delete of employee from tbl\_employee, I am trying to insert info into tbl\_audit. 

I am hard coding the values for tblname and columnnames, but I cannot figure out how to get all the values from the deleted row into the columnvalues column (comma delimited). 

Any guidance would greatly be appreciated.

**example**: employee 1 is deleted

```
CREATE TRIGGER TRIGGER_DELETE
ON tbl_employee
FOR DELETE
AS
 INSERT INTO tbl_audit  (tblName, columnNames, columnValues)
 VALUES 
 (
 'tbl_employee',
 'id, name, source',
 SELECT STUFF(select ',' + tbl_employee.id, tbl_employee.name, tbl_employee.source FROM DELETED WHERE tbl_employee.id IN(SELECT deleted.id FROM deleted)) 
 ) 
  WHERE tbl_employee.id IN(SELECT deleted.id FROM deleted)

```