Why not terminate your loop after 40 and why all the cursors?

DECLARE @temp nvarchar(200) 

DECLARE @email_campaign_id as int, 

@status int, 

@start_datetime datetime, 

@email_max_quantity int, 

@email_quantity...

If id is sequential, then try this

select a.field1, a.field2, a.id 

from table a 

left outer join table b 

on b.id = (a.id -1) 

and (b.field1...

quote:

---

CONTAINS(ctx_desc,'"Bohrer" AND "Hartmetall" AND "3.0"')

---

This is exactly how I use Full Text Search.

I...

The query I posted worked fine for me, with single or double quotes.

However ckempste's does not?

What version of sql are you on, I'm on SLQ7 SP4.

Andy, cannot find the content, is there a problem?

The last time I did something like this was to use a same name for the fields which results in an array of results. I then use the length of...

Update dbo.table

set c_alias = 'Test'

where c_alias IN ('Work', 'Book', 'Event') 

This will replace c_alias with Test where it is either Work,Book or Event. Is this what...

Use SQLCHAR for the input fields, sql server will convert where necessary. SQLINT expects the data to be binary.

Put quotes around text you want found

where contains(indexedcolumn,"3.0") 

quote:

---

can't let loose from work?

---

Nah! Week hols Frank, just keeping in touch with the...

Sure interesting the number of times this type of problem crops up. For problems like this cursors seem the best bet as trying to build a dynamic query can sometimes...

OK now I understand the problem. My suggestion is that if you want to avoid cursors, I would do the following

On each table (tdSei and tdSit in this eaxmple) add...

This is my original attempt

SELECTa.SEQ,a.KukS,

b.SeRyCD,b.SeFl,

c.SiRyCD,c.SiFl

FROMtdKuk a

LEFT OUTER JOIN tdSei b

ON b.SEQ = a.SEQ AND b.KukS = a.KukS 

LEFT OUTER JOIN tdSit c

ON c.SEQ = a.SEQ...

In the target database, I would update matches first

UPDATE d 

SET d.col1=s.col1, 

d.col2=s.col2 

... 

FROM destinationtable d 

INNER JOIN sourcedatabase..sourcetable s 

ON s.key = d.key...

My solution was similar to Jonathan's but I had reservations about performance using it against 200,000 records. If it is a one off then... as long as it works. I'd...