The only way I know of doing something like this is to do and export data task from 2005 to 2000.  BUt you only get a few objects that way...

Just to complete and correct what I said :

IF 0 < OBJECT_ID('tempdb..#a')

 DROP TABLE tempdb..#a

whill throw this message :

Database name 'tempdb' ignored, referencing object in tempdb.

Database name 'tempdb' ignored,...

Won't work because the object is only contained in tempdb.  You can actually access the table from any other database as long as you are still using the same connection...

We don't need to see actual data (even if it's always better to have real life data).

Can you provide a few rows of fake data and the required output you need? ...

Jeff, my question still stands... how the heck do I change your formula to apply it on 4 or more columns ?

Sure we'll keep helping.

I suggest you post some sample data from the table and the required results.  That way we will be able to give you the correct query.

Also why did...

Hey Jeff, care to explain how you can expand your formula to any number of columns to compare?

I would tend to agree but there may be some strange business logic in there so I don't want to say something I'll later regret

Thanx for the honesty .

Can we see the code you execute in the sp?

Have you tried hitting the refresh at the table level?

That's the safest way to do it :

CREATE TABLE #A (n int)

SELECT * from #A

IF 0 < OBJECT_ID('tempdb..#a')

 DROP TABLE #A

SELECT * from #A

--generates error because table is dropped

The like...

You might want to read this :

http://www.sommarskog.se/dyn-search.html

http://www.sommarskog.se/dynamic_sql.html

How about we use the good old case statment??

--===== If the test table exists, drop it

    SET NOCOUNT ON

     IF OBJECT_ID('TempDB..#MyHead') IS NOT NULL

        DROP TABLE #MyHead

GO

--===== Create the test...

Have you tried running this query on both levels to see if it returns the same set?

SELECT f.hz, f.amp

FROM freq f (NOLOCK)

right outer join outcome o (NOLOCK) on o.id =...