SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE [dbo].[tblQuestionsSample](
    [QuestionsRecID] [int] IDENTITY(1,1) NOT NULL,
    [Question_ID] [int] NULL,
    [Question_Text] [varchar](1000) NULL,
    [Question_Text2] [varchar](1000) NULL
 CONSTRAINT [PK_dbo.[QuestionsRecID] PRIMARY KEY CLUSTERED 
(
    [QuestionsRecID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

INSERT INTO [dbo].[tblQuestionsSample]
 ([Question_ID]
 ,[Question_Text]
 ,[Question_Text2])
 VALUES
 (11603,'Date/Time','Date/Tim')
 ,(11632,'Attachments','Attachment')
 ,(12166,'Employee ID','Employee I')
 ,(12166,'Work Related?','Work Related')
 ,(12165,'Date &amp; Time of injury/onset illness?','Date &amp; Time of injury/onset illness')
 ,(12165,'Full Injury/Illness Description','Full Injury/Illness Descriptio')
 ,(12165,'Job Title','Job Titl')

7 rows affected

QuestionsRecID	Question_ID	Question_Text	Question_Text2	Question_Text_Parsed
1	11603	<p>Date/Time</p>	Date/Tim	Date/Time
2	11632	<p>Attachments</p>	Attachment	Attachments
3	12166	<p>Employee ID</p>	Employee I	Employee ID
4	12166	<p>Work Related?</p>	Work Related	Work Related?
5	12165	<p>Date & Time of injury/onset illness?</p>	Date & Time of injury/onset illness	Date & Time of injury/onset illness?
6	12165	<p>Full Injury/Illness Description</p>	Full Injury/Illness Descriptio	Full Injury/Illness Description
7	12165	<p>Job Title</p>	Job Titl	Job Title