Hi All

I have changed existing procedure in which I have added new table as join . Query already has 5 joins from physical table and one temp table . I adding join to this new table and existing temporary table (#) .

Whenever the new table has some records procedure get hung . If I truncate data from new table it works fine .

If I execute sp_lock I see 12 records 10 for non cursor lock on physical table and 2 on temporary table .

Can someone please help me on this .