You could use an insert/update Trigger

ok but that is still to manual. That takes someone opening it. I want it so it sends out refreshed using the SQL server only.

Ctrl+Shift -Teb

The OR statement worked but the performance changed from 2 min to 42 min query. I also found that there is some duplication in the Sales data between your_reference...

This is probably pretty late but if you never found the answer this will work on 2k

DBCC SHRINKDATABASE (N'Hr_database', 0,TRUNCATEONLY)

I do not think you can. You would have to use a linked server and write a script to compare the two tables

This is a rough answer but using excel you can do both mdx and link to the data using pivot tables. That would be under data import and choose...

Yup all those things are what I am doing. So I need to grant execute rights only to specific Procs. Is there a good way to handle this? ...

What about a UDF. I think I may go that way

I understand what you guys are saying but when I do the top 5 thing I only get 5 records. I need the top 5 per customer/item combination. ...

These are unposted sales orders. This is an alert to notify of Quantity out of tolerance. Cost has no berring. Basically this is to help in...

Wow that was pretty cool. I never new that. I of course shared this to co-workers and got kudos. Thanks a ton. that helps me in...

Also FYI on the maintanence task of deleting old back ups. I had a problem where it would not delete the old files. It was looking for extension...

From the sounds of it you need a relational Cube so that changes are reflected. Problem with that is I do not think you can do that once a...

I have had this problem. The only solution I found was this site

http://www.orafaq.com/forum/t/38079/0/

This solution will only work on a 32 bit system. If you are on...