hi,
I wrote the sp. but im getting the error as
Msg 9411, Level 16, State 1, Procedure sp_delimiterexample1, Line 5
XML parsing: line 1, character 43, semicolon expected.
here is my stored procedue..
alter proc [dbo].[sp_delimiterexample1]
@level_id
varchar(50),
@grp_id
varchar(50)
as
SELECT
F1.video_title, F1.video_drills, O.splitvideo
FROM
(
SELECT *,cast('<x>'+replace(F.video_drills,',','</x><x>')+'</x>' as XML) as xmlfilter from tns_course_mst F )F1
CROSS APPLY(
SELECT video_drills.D.value('.','varchar(max)') as splitvideo
FROM f1.xmlfilter.nodes('x') as video_drills(D)) O where level_id=@level_id and grp_id=@grp_id
an anyone say where ui went wrong.