Splits input strings in the stored procedure and inserts them into the table.

A newly written SQL code is used in the stored procedure to split input strings and insert them into the table:

I don't know if the efficiency is high? (Please advise)

Declare @ SQL nvarchar (4000)
Set @ SQL = Replace (@ Vote, '|', 'Union all select ')
Set @ SQL = 'select' + @ SQL
Set @ SQL = Replace (@ SQL, 'select', 'select' + cast (@ Topic_ID as nvarchar (20) + ', '+ cast (@ VoteType as nvarchar (2) +', ''' + Convert (nvarchar (10), DateAdd (d, @ OutTime, getdate (), 120) + ''',')
Set @ SQL = 'insert Forum_Vote (Topic_ID, VoteType, TimeOut, Vote) '+ @ SQL
Exec (@ SQL)