Hi ,
i have this table Testers
employee name
------------
Sam Korch
dan mano
i want to combine tow rows to one, it will be "Sam Korch,Dan Mano"
i have this query
select @theString = COALESCE(@theString + ',', '') + EmployeeName
from Testers join vw_EKDIR on Testers.TesterGlobalId = vw_EKDIR.GlobalID
where TestId = 31
it working but i dont want to do select i want the result will be in @thestring
so i try to do this query
set @theString = (
select @theString = COALESCE(@theString + ',', '') + EmployeeName
from Testers join vw_EKDIR on Testers.TesterGlobalId = vw_EKDIR.GlobalID
where TestId = 31
)
it is not working ... i want @thestring will be the result.
any idaes ?
thanks