Have you considered using an ActiveX Script in DTS? This would allow you to set the variables for the tables each time you run the job, and handle the scrubbing...

Hi wenny,

you can also use a full outer join like this

SELECT  distinct   CASE  ISNULL( t2.[name],'') 

When '' THEN  t1.[name]

else t2.name  

end AS name, t1.feb, t2.March

FROM         t1 full OUTER join

                      t2...

Our Company has worked with Universe since 1982 and We are Turning it off!

As in the other posts, there is very limited support available and it costs us twice as...