thank you for all finally i find solutions
CREATE PROCEDURE [dbo].[EI_SP_SPLIT]
@Strings NVARCHAR(MAX),
@Separetor NVARCHAR(1)=null
AS
BEGIN
SET NOCOUNT ON;
DECLARE @COUNT INT
SET @COUNT=LEN(@Strings)
WHILE @COUNT > 0
BEGIN
if
(ASCII(LEFT(RIGHT(@Strings,@COUNT),1))> = 33 and ASCII(LEFT(RIGHT(@Strings,@COUNT),1))< =47)
OR
(ASCII(LEFT(RIGHT(@Strings,@COUNT),1))> = 58 and ASCII(LEFT(RIGHT(@Strings,@COUNT),1))< =64)
OR
(ASCII(LEFT(RIGHT(@Strings,@COUNT),1))> = 91 and ASCII(LEFT(RIGHT(@Strings,@COUNT),1))< =96)
OR
(ASCII(LEFT(RIGHT(@Strings,@COUNT),1))> = 123 and ASCII(LEFT(RIGHT(@Strings,@COUNT),1))< =127)
and
(@Separetor is not null)
begin
set @Separetor =LEFT(RIGHT(@Strings,@COUNT),1)
END
SET @COUNT=@COUNT-1
END
IF @Strings IS NOT NULL
BEGIN
DECLARE @INPUT NVARCHAR(MAX)
DECLARE @OUTPUT NVARCHAR(MAX)
if (right(@Strings,1) <> @Separetor )
begin
set @Strings = @Strings + @Separetor
end
create table #temp
(
Strings nvarchar(max)
)
SET @COUNT= len(@Strings)-len(replace(@Strings,@Separetor,''))
WHILE @COUNT > 0
BEGIN
SET @INPUT = left( @Strings,(Charindex(@Separetor,@Strings))-1)
SET @Strings = right( @Strings,len(@Strings)-(Charindex(@Separetor,@Strings)))
SET @COUNT=@COUNT-1
insert into #temp
(Strings)values(@INPUT)
END
SET @OUTPUT='select * from #temp '
EXEC (@OUTPUT)
END
END
exec ei_sp_split'Try%this%one'