Thanks for your reply Chris.

This database is for a research study automation software where users will create their research papers/journals. A research paper might have many different sections (title &...

Guys, no one??

Folks

I'll tend to drift away from the actual subject here, that is from Full text and search pattern.

When I run a select * from on the attached table with the...

Thanks for the prompt elaboration, appreciate.

We are on the same page here, I was just confused where you mentioned partial word search. Um.. I have a gut feeling that...

Thank you for the reply, double storing might be the last resort, an ultimate dead end.

Anything searched would have to be a partial word search, which means cat and...

I guess my second post implied storing a 600 pager PDF as a binary object, which is not the case. The system will compile and format the data in the...

No one, still?

Hi Jeff thanks for your reply

I am attaching a sample text file here. I have prepared it on the same lines as the original document. As for the length of...

Thanks for the reply Lutz. Ill try to sketch out the scenario below;

The application we are currently working upon is aimed at research automation where a research paper/study would be...

Folks, no one after 46 views :)? I guess I did not convey the problem correctly, or posted it in the wrong section. Yet look forward to a solution.

Thanks,

Kazim

Hi,

Thanks for the script, I have implemented it this way;

if OBJECT_ID('tempdb..#TempTable') is not null drop table #TempTable if OBJECT_ID('tempdb..#Output') is not null drop table #Output

create table #Source

(

UserID varchar(10)

,ChangeDate...

apologies for the delayed response, I was on may to home.

You are right, OrderID should not be there, since it is constant. Actually, whatever hasn't changed should not be there....

home -> work instead of home -> shop means when the record inserted, it carried the value home, then it was updated to work and then updated to shop. Means,...

Apologies for inconvenience, hope the following gives a clear picture

if OBJECT_ID('tempdb..#TempTable') is not null drop table #TempTable

if OBJECT_ID('tempdb..#Output') is not null drop table #Output

create table #Source

(

UserID nvarchar(10)

,ChangeDate datetime

,OrderID nvarchar(20)

,Address1...

Certainly not; or else; what will our friend do 😛

By brainstorming I meant just to take a high level review or opinion...

~ Kazim Raza