How often do you need to copy the data? Will the database on the test server be updated?

Thanks Frank. However, I'm really asking, is there a way to write this query without utilizing a derived table.

What RonClarke said.

When I said that the subquery returns all the values in table1, I meant all of the values for the column specified in...

Let me clarify.

Since the subselect evaluates as select code from table1, table2, you get a cartesian product. In other words, you get all of the values from table1 repeated...

I'm currently running SQL Server 2000 Developer Edition on XP Pro.

Not all of the features of Analysis Services are available, but that's about it.

ThomasH, you are correct in that the subselect will evaluate to

select code from table1, table2.

That query returns no rows. Thus, including it in the main query will result in...

We definately need more info as Frank Kalis and whoteegan point out. However, here's a shot in the dark. If the SP works well once or twice and...

What is the structure of your table?

I was thrown by the same thing. None of the answers looked correct to me.

I agree with whoteegan.

Also, you can't use Windows authentication in this manner if there is a domain involved.