sorry mate if i didn't clearly understood the problem..
i guess i was barking at the wrong tree.. heheheh

btw,that solution that i proposed is well tested..
it is used for some of...

----------------------------------------------------------
-- select all the records that matches our criteria
selectp.url as 'url'
, count(*) as 'occurrences'
        fromtblPage p
jointblOccurrence o on((o.page_id = p.page_id))
jointblWord w on (w.word_id...

if  exists (select name from sys.databases where name = N'narraSoft_DB')
begin
drop database narraSoft_DB
end
go

create database narraSoft_DB
go

use narraSoft_DB
go

create table Employee
(
employee_id int identity(1,1) constraint employee_pk primary key clustered,
employee_name nvarchar(200)
)
go

--dummy data
insert into Employee(employee_name)
values('Niladri Saha')
insert...

create procedure usp_SimpleSearchEngine
(
@xmlKeywords nvarchar(max)
)
as

--<root>
--<item word=""/>
--</root>

begin
declare @hdoc INT
declare @xml nvarchar(max)
declare @Keywords table(word nvarchar(200))

--parse the xml and save them in the variable table
exec sp_xml_preparedocument @hdoc output, @xmlKeywords

insert into @Keywords(word)
select  tmp.word from...