INSERT INTO
dbo.Logtable (AdditionalInfo)
SELECT
'Another Process with ID: ' + CAST(ID AS VARCHAR(25)) + ' is currently in use')
FROM
[CBH]
WHERE
[SID] = 2;
INSERT INTO
dbo.Logtable (AdditionalInfo)
SELECT
'Another Process with ID: ' + CAST(ID AS VARCHAR(25)) + ' is currently in use')
FROM
[PBH]
WHERE
[SID] = 2;