Tried this:

Select groupid, [line number], [to]-[from] as ToFrom,

MAX([to]-[from]) over (partition by groupid

order by [line number]

rows between 1 Preceding

AND 1 preceding) as prevToFrom,

MAX([to]-[from]) over (partition by groupid

order...

I am using SQL Server 2008. Line Number controls the order. Here is some test data to use for my example:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

--===== If the test...

there is a column called ID, which is a unique column.

This is data I OCR'd and The contract number can show up multiple times in the file. It is a multi-page tif image. Sometimes the contract number is...

When I changed the fourth line to point to the Table/column it gives me an error msg. I forgot to mention, FullText has a lot more text in the...

Thanks, this is very helpful

Your too quick for me... I just edited my original post. Please see new requirement.

thanks

Thanks, it was very close and useful. I ended up with this :

WITH DtlIdxcolumn (tblnm,type_desc,object_id,index_id,column_id,name)

AS

-- Define the CTE query.

(

select main.name as tblnm,main.type_desc,Sec.*

...

Can you give me an example of how to do this?

Yes, I did resolve it...trial and error...then got it.

thanks

Before I do this, what exactly does this do?

Found it and installed it. I have to reboot the server, so I will have to wait till end of the day to reboot. I'll try it later....

I have windows 2008 R2 and I don't see powershell anywhere and can't find it to install it on my OS. It is 32 bit. Is it already...

2 db's were able to attach, the others did not and they are all in the same folder.

Yes, checked rights and read only checkbox on folder and on file. I even moved the sql files to the default location for sql data files.