Hi Adam,

The solution you provided works great on SQL2005 which is what this forum is for. Can we use something similar for SQL 2000.

Thanks

Thank you guys for your suggestions i ended up bringing that subquery out in a separate view and then did a join on it.

Hi Adam,

I was looking at something similar to what you provided. it works great thanks.

Abhi

Gift,

but i do not want to store the entire word document in the database. I want to extract the contents from the document line by line and store it accordingly....

hi All,

now there is a slight change in the insertions. Is it possible to insert words equation objects in the table fields.

It can be any thing for ex: y=-3x-4.right now...

I created views and then did joins on the combination of views and was able to achieve what i wanted .....but was wondering if there is any quicker,efficient way to...