lanky_doodle - Thursday, May 3, 2018 5:39 AM

Hello,

Is there anyway I can replicate this within an INSERT/OUTPUT statement:

declare @ID as table(ID uniqueidentifier);

insert intotbl_Link_Update_History

outputinserted.ID into @ID

values(newid(), @LinkID, getdate(), @user-id);

selectdbo.fnc_FormatDate(luh.Updated_Date, 106) + ' (' + u.Forename + ' ' + u.Surname + ')'

fromtbl_Link_Update_History luh join

tbl_Users u on u.[User_ID] = luh.Updated_By_ID

whereluh.ID =

(

selectID

from@ID

);

The needed result is a scalar value: 1 January 1900 (Firstname Lastname)

Thanks