• You should use a funcation.

    define a funcation like

    CREATE FUNCTION [dbo].[SplittingByDot]

    (

    @SourceData varchar(255)

    )

    RETURNS NVARCHAR

    AS

    BEGIN

    ......

    END

    then use the

    SELECT dbo.SplittingByDot(OutlineNumber) FROM dbo.Tally

    get the result