CREATE TABLE KLN
(RecId INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,
Dte DATETIME,
machineid VARCHAR(50),
Userid VARCHAR(50),
memo text)

CREATE  PROCEDURE [dbo].[Save_kln]
@sDte as datetime,
@smachineid as varchar(50),
@sUserid as varchar(50),
@smemo as text

AS
DECLARE @sRESULTS varchar(MAX)
if exists (select * from [kln] where [dte] = @sdte and Userid = @Suserid)
begin
set @sRESULTS = (select memo from [kln] where [dte] = @sdte and Userid = @Suserid)
update [kln] set memo = @sRESULTS + @smemo where [dte] = @sdte and Userid = @Suserid
end
else
begin
INSERT INTO [kln] (dte,machineid,userid,memo) VALUES (@sdte,@smachineid,@suserid,@smemo)
end

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass