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
select	p.url as 'url'
			, count(*) as 'occurrences'
        from	tblPage p
	join	tblOccurrence o on((o.page_id = p.page_id))
	join	tblWord 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...