declare
@I_vCOMMENT_1 CHAR(50) = '',
@I_vCOMMENT_2 CHAR(50) = '',
@I_vCOMMENT_3 CHAR(50) = '',
@I_vCOMMENT_4 CHAR(50) = '',
@I_vCMMTTEXT VARCHAR(500) = '11111111 2222 3333 4444 555 666 7777 8888 9999 0000 aaaa ssss dddd ffff gggg zzzz xxxx cccc vvvv bbbb',
@iStatus int
EXEC @iStatus = taParseCommentText @I_vCMMTTEXT = @I_vCMMTTEXT,
@O_COMMENT_1 = @I_vCOMMENT_1 OUTPUT,
@O_COMMENT_2 = @I_vCOMMENT_2 OUTPUT,
@O_COMMENT_3 = @I_vCOMMENT_3 OUTPUT,
@O_COMMENT_4 = @I_vCOMMENT_4 OUTPUT;
SELECT
@iStatus,
@I_vCOMMENT_1,
@I_vCOMMENT_2 ,
@I_vCOMMENT_3 ,
@I_vCOMMENT_4 ,
@I_vCMMTTEXT