Update output format , Sql Server

Language: Layout:

-- Status list definition
CREATE TABLE t_statuses (
  id int IDENTITY(1,1) PRIMARY KEY,
  description varchar(50)
);

INSERT INTO t_statuses (description)
VALUES ('A'), ('B'), ('C'), ('D'), ('E');

-- Messages queue definition
CREATE TABLE t_queue (
  id int IDENTITY(1,1) PRIMARY KEY,
  status_code int FOREIGN KEY REFERENCES t_statuses (id) DEFAULT 1,
  message varchar(50)
);

-- STATUS HISTORY
CREATE TABLE t_statusHistory (
  id int IDENTITY(1,1) PRIMARY KEY,
  message int FOREIGN KEY REFERENCES t_queue (id),
  status_code int NOT NULL,
  stamp datetime DEFAULT GETDATE()
);

GO
CREATE TRIGGER logStatusHistory
ON t_queue
AFTER INSERT, UPDATE
AS
INSERT INTO t_statusHistory (message, status_code)
SELECT i.id, i.status_code
FROM inserted i LEFT JOIN deleted d ON i.id = d.id
WHERE ISNULL(i.status_code, -1000) <> ISNULL(d.status_code, -1000);

-- Fill the queue. It must be included to the history.
GO
INSERT INTO t_queue (message)
VALUES ('First message'), ('Second message'), ('Message 3'), ('Message 4'), ('Message 5');

-- Update statuses of all messages. It must be included to the history.
UPDATE t_queue
SET status_code = 2;

-- Update a message text. The changes must be ignored in the history.
UPDATE t_queue
SET message = 'Message 1'
WHERE message LIKE '%First%';

UPDATE t_queue
SET message = 'Message 2'
WHERE message LIKE '%Second%';

-- It does not change status and must be ignored in the history.
UPDATE t_queue
SET status_code = 2
WHERE message LIKE '%3%';

-- Update a message status. It must be included to the history.
UPDATE t_queue
SET status_code = 3
WHERE message LIKE '%4%';

UPDATE t_queue
SET status_code = 4
WHERE message LIKE '%1%' OR message LIKE '%4%';

-- Show the history of statuses.
SELECT
    h.stamp,
    q.message,
    s.description [status]
FROM
    t_statusHistory h
LEFT JOIN
    t_queue q ON h.message = q.id
LEFT JOIN
    t_statuses s ON h.status_code = s.id
ORDER BY h.id;

View schema
Execution time: 0,09 sec, rows selected: 13, rows affected: 34, absolute service time: 0,42 sec, absolute service time: 0,43 sec