SQLKnowItAll (7/30/2012)
What do you mean by "it does not work?" You mean it never completes? I assume you have a create table statement for your temporary table or a SELECT INTO. Are you sure that statement is completeing? What is your entire script?
"it does not work" means it finishes with constraint violation, and therefore no insertion is done.
Regards
IgorMi
Igor Micev,My blog: www.igormicev.com