Could you please specify all conditions you have

Your trigger is written in such way that it can only work for update/insert of a single record at the time. It's a classical example of how "never write your...

It does actually look like parameter sniffing...

But, if it's not blocked or other, try to add Option (MAXDOP 1)

Are you running on SQL2008?

I thought there is a concept of "short-circuiting" in sql server. Try the following.

SELECT 1 WHERE (1 = 1) OR (1 / 0 = 0)

even if there is a division...

pravasis (5/28/2012)

---

Dung Dinh (5/28/2012)

---

I'm sure that with the sample data and your query. The result is always 2 records

idname1name2desc

1test1 test2 ...

That is exactly what I've described (even a bit more).

It returns two rows as single record in Test_Join_Source2 matches two different records in Test_Join_Destination2:

it matches the first one on...

OP has two records as it matches to two different records in table she JOINs to, one record matches on ONE column and another record matches on SECOND column.

OP...

Could you please post the complete trigger code.

I've done it before in a place when standard SQL replication wasn't allowed for stupid reason.

You will need to create custom triggers to capture change and build appropriate DML. The...

Schadenfreude-Mei (5/28/2012)

---

pdanes (5/28/2012)

---

Eugene Elutin (5/24/2012)

---

P.S. There is an universal solution to stop queries running forever:

Ask electrician to connect your server room power supply via your floor light switch, so...

I can say (reading detailed DIY advices here)...

Duplicate Post!

http://www.sqlservercentral.com/Forums/Topic1307219-391-1.aspx

If guidsource in dbo.LR_TABLE_TEST is unique, ou can try this way:

SELECT * INTO dbo.LR_TABLE_TEST_1

FROM (SELECT ROW_NUMBER() OVER (ORDER BY guidsource) AS RN, * FROM dbo.LR_TABLE_TEST) q

WHERE RN...

anthony.green (5/28/2012)

---

external seal wont be an option as its on a joining wall with next door so, can only treat it from the inside, but yeah it is good stuff,...

I guess this thread should be placed into dedicated forum. Can be called "All SQL in 15 minutes"

or "What I'm going to do on this weekend"

Any other ideas?