SELECT largeTable.[field1], ...

FROM

largeTable

WHERE

exists(SELECT * FROM #tmpTable WHERE #tmpTabel.Number = largeTable.Number %10000)

If for each row in temp table only one matching row in the large table exists you could use

SELECT...

Hi,

I think that the same thing can be obtained in a much simpler and effective manner.

The problem consists in updating the IsSelected flag for all topics of a specific...