Thats great. Glad to hear 🙂

If you don't mind, can you post your trigger code?

We will check and let you know of improvements if any..

You might appreciate a complete answer but it will not help you...

You will need to create a trigger check if the column has been updated

If the column has been updated, you can do a ROLLBACK in the trigger with a possible...

It depends. You will have to test both the queries and check the execution plans.

Sometimes, performance changes when there is change in the Volume of data.

Hence, I would advise you...

You will have to use an INSERT..SELECT option

INSERTINTO [PLSy]( <<Column1>>, <<Column2>>, ....<<Columnn>> )

SELECT<<Column1>>, <<Column2>>, ....<<Columnn>>

FROM[srv5].[DB].[dbo].[PLSo] -- Navision

WHERE[timestamp] NOT IN ( SELECT [timestamp] FROM [PLSy])

Another better way would be to use...

What is the recovery model of your database? Is suspect it to be FULL.

If your recovery model is FULL, follow the below steps

1. Take a full database backup

2. Shrink the...

The link below has a book on SQL Server Profiler by Brad McGehee

http://www.sqlservercentral.com/articles/books/65797/

Try creating a UNIQUE KEY constraint with both the columns on GV_Voucher table.

Your FOREIGN KEY constraint in GV_ReceivedOffice table should again be based on these 2 columns.

ALTER TABLE GV_ReceivedOffice ADD...

Michael L John (4/26/2013)

---

That's your answer. Account_id is the primary key. It is already unique. The use of distinct will produce the same number of rows as...

Duplicate post. Please post your replies here.

http://www.sqlservercentral.com/Forums/Topic1446842-1292-1.aspx

What would be the expected output if your results looked like this and why?

The Second SQL Statement Result was like below one,

ID NAME HOURS

1 AAA 20

2 BBB 30

3 CCC 0

4...

In your table GV_Voucher, the column TransactionID has not been defined as a UNIQUE KEY

You will have to make TransactionID a UNIQUE KEY in GV_Voucher to create this FOREIGN KEY...

Is it possible for TransactionID to be duplicated in the table GV_Voucher?

If the answer is No, then you can fetch it based on VoucherNo's else you will need TransactionID in...

iam777here4u (4/25/2013)

---

Thank you so much Kingston... that works. I will be implementing your logic in my original script. I hope using CTE for millions of data is okay. Let you...

sd_xxx_sd (4/24/2013)

---

Hi Everyone,

I have a problem with triggers. Trigger must be fired and update COLUMN_A in TABLE2 after insert COLUMN_B in TABLE 1 . Have anyone some idea ?...