Thanks for your reply. I'll give it a go although Chris (below) seems to think it might not be the solution for this situation.

Hi, and thanks for your reply.

It's two tables. One contains a new imported list of organisations - the other is the existing list of organisations (about 10,000 rows in the...

BrainDonor (9/7/2010)

---

I rarely rate a subject, but this one deserves it in my opinion, in order to draw people's attention to it. I think everyone should know how SQL Injection...

Perry Whittle (9/6/2010)

---

possibly many avenues to achieve this on an unsecured server

sku370870 (9/6/2010)

---

How can you not show passwords in a...

How would a hacker get to see a web.config file?

How can you not show passwords in a web.config file for the account which is accessing a database?

Thanks for your replies.

If the Inserted and Deleted tables always exist for the duration of a trigger ... if you write a trigger for INSERT, UPDATE and DELETE - what...

Thanks for your reply.

The query you suggested will return nothing because, as far as I can see, there is no way to delete a product within the system and, in...

Oops! I've been doing Maths since I was 5 and it never occurred to me it meant 'join on the ProductIDs minus 1'.

But, the code is in a trigger...

Thanks for the replies.

The whole record is duplicated.

Thanks again for your replies. There is no chance of getting better data. The organisation in question is about to start using a new system - the only list of...

I have SQL Server Management Studio 10.0.2531.0

What is SSIS? Do I have it? How can I find it?

Thanks for your replies.

Thanks for your answer.

Yes, the existing organisation table - has a primary key. The other table is an import from an excel spreadsheet that just contains the names and addresses...

Thank you.

Thanks again to everyone for your help.

One last question. Say I had four postcodes with IDs of 1, 2, 3, and 4

I could structure a table with two PostcodeID columns...

Thanks for your reply.

If I wanted to use the pre-computed table for other things - do you think the 8 million row version would be manageable?