TSQL Merge statement hanging

Question

I currently run the following statement and the query never completes. I am unsure why as I use the same query with other source tables and it completes very quickly, this source table is not bigger.

 merge into dbo.Tickets_Amends as target
 using  dbo.Tickets_Healthchecks_parentlesstickets as source
 on     (target.fault_ID = source.fault_ID)
 when not matched by target then 
 insert  (fault_ID) values (source.fault_ID);
 GO

Any ideas on how I can establish the error here ?

Answer 1

Nevermind, this was a datatype mis-match