Variation of above with a loop. You can wrap this in a proc and pass text.

CREATE TABLE #temp (rowid int,textcol ntext) 

INSERT INTO  #temp...

BOL will give you details and examples of ntext search & replace using PATINDEX, DATALENGTH, TEXTPTR, UPDATETEXT etc.

Do you want to update the ntext col or use it in a...

Rough solution (not tested)

DECLARE @RecCount int

SET @RecCount = 1

CREATE TABLE #TempDoc (DocumentID int) 

CREATE TABLE #TempDoc1 (DocumentID int) 

CREATE TABLE #TempDoc2 (DocumentID int) 

INSERT INTO...

Yeah, buffer overrun or more probably memory leak!

OK Frank,

Stupdi me, figner troublle agin....

should have been 'for 3 weeks'.

Started off as a programmer (Woolworths UK) in 1976 with ICL 1900 mainframe using COBOL and ICL IDMS databases, progressed to ICL 2900, ICL ME29. Made redundant, Joined Colt and...

Hi Frank,

Naming names eh! That's not fair. I would have responded anyway but out of the office for 3 weeks (as you know) and BTW thanks for the emails.

As for...

In that case can you post the table definition and some sample data in that format and is there a maximum number of 'Comp' values?

As Allen's post alludes to, openquery must have a resultset returned. You can fool sql server by appending a dummy select to the query. In sql server I would do...

Here's a solution using dynamic sql

declare @max int 

declare @ct int 

declare @sql nvarchar(250) 

select @max = max(Comp) from tablea 

create table #newtable ([ID] int)...

Don't know about functions (I'm on SQL7) but I suppose you could write a function to return a result of lookup for username in master..syslogins and check sysadmin, securityadmin, serveradmin,...

BOL = Books OnLine. It's SQL Server help manual if you like. It is installed when you install SQL Server or the client tools. It is the first place I...

No, I was referring to the function. According to my BOL (SQL7) you can supply a seed for the IDENTITY function but it does not imply that you can use...

Can you post the format file and some sample (non sensitive) data.

Is there anything in the tables to identify the rows to enable a match. Without any row numbering even cursors may give you inconsistent results, remember sql server does not...