I have the following MSSQL line in my trigger
declare @varID varchar(1000)
set @varID = (SELECT [varID] FROM deleted)
the problem is that the query is returning more than one value and is causing an erro.
So let's say value1,value2 and value3
I want the varID to be equal to "value1,value2,value3"
How can i do that ?