help help help(sql) :(

[mjayanatha]

CREATE FUNCTION [dbo].[fnParseStringTSQL] (@string NVARCHAR(MAX),@separator NCHAR(1))
RETURNS @parsedString TABLE (stdmarks NVARCHAR(MAX))
AS
BEGIN
DECLARE @position int
SET @position = 1
SET @string = @string + @separator
WHILE charindex(@separator,@string,@position) <> 0
BEGIN
INSERT into @parsedString
SELECT substring(@string, @position, charindex(@separator,@string,@position) - @position)
SET @position = charindex(@separator,@string,@position) + 1
END
RETURN
END
go

select t.stdId, p.stdmarks
from tba t
cross apply [dbo].[fnParseStringTSQL](t.stdmarks,',') p



drop function [dbo].[fnParseStringTSQL]



pana giya machan

 

[mjayanatha]

new query window ekak aragena kalin sql eka past karala .... ube table name eka dapan machan...ethakota hari....... (mama red eken tba kiyala dala thiyenne table eka)

 

[ad.hasareli]

CREATE FUNCTION [dbo].[fnParseStringTSQL] (@string NVARCHAR(MAX),@separator NCHAR(1))
RETURNS @parsedString TABLE (stdmarks NVARCHAR(MAX))
AS
BEGIN
DECLARE @position int
SET @position = 1
SET @string = @string + @separator
WHILE charindex(@separator,@string,@position) <> 0
BEGIN
INSERT into @parsedString
SELECT substring(@string, @position, charindex(@separator,@string,@position) - @position)
SET @position = charindex(@separator,@string,@position) + 1
END
RETURN
END
go

select t.stdId, p.stdmarks
from tba t
cross apply [dbo].[fnParseStringTSQL](t.stdmarks,',') p



drop function [dbo].[fnParseStringTSQL]



pana giya machan

Machan wede hari.... thnxxxxxxxx thanxxxxx thanxxxxxxx a lot machan

 

[hansa1018]

CREATE FUNCTION [dbo].[fnParseStringTSQL] (@string NVARCHAR(MAX),@separator NCHAR(1))
RETURNS @parsedString TABLE (stdmarks NVARCHAR(MAX))
AS
BEGIN
DECLARE @position int
SET @position = 1
SET @string = @string + @separator
WHILE charindex(@separator,@string,@position) <> 0
BEGIN
INSERT into @parsedString
SELECT substring(@string, @position, charindex(@separator,@string,@position) - @position)
SET @position = charindex(@separator,@string,@position) + 1
END
RETURN
END
go

select t.stdId, p.stdmarks
from tba t
cross apply [dbo].[fnParseStringTSQL](t.stdmarks,',') p



drop function [dbo].[fnParseStringTSQL]



pana giya machan

elaazz...................