Report Server?

Why do 1 insert call per temp table row on a 10,000 row temp table?

just

INSERT

INTO [dbo].[Computers]([NetBIOSName], 127.0.0.1)

select netbiosname,ip from temptable

where temptable.netbiosname not in ( select netbiosname from computers))

drop the indexes

try a simple select top 10 * from table

rebuild the indexes

or

export, drop and rebuild the table

//one or more characters had no match in the target code page//

seems to be wierd characters,

you could try a varbinary field instead of varchar

Careful, none of the answers given test for your Date requirement!

you can reduce that whole mess to a 'set based' solution, even better use it to create a view!

set @ResidenceAddress = (select case isnull(AddressLine1) when '' else Addressline1+ ',' end...