Yet another good article on the use of temp tables. And once again I think it highlights the fact that you can't generalize what is or isn't good practice.

Sure table...

If you wanted to avoid usiing extended stored prcedures you could do it like this. It's a bit more understandable than multiple nested select statements that are required...

Right! I thought I'd look at adapting this script yet again to use the new system views in SQL2005, when I started to think that this is a really great...

Thanks for you reply Vincent.

Rob.

I'm not sure I entirely understand your argument for an ODS in this context. The only difference between that and the warehouse is that the ODS may not encompass the...

Just as an aside, the use of the 'In' function in your example is really a bad choice for what you are trying to achieve.

You would be far better off...

To try and anser this I'll have to make a couple of assumptions... you have some fact, says sales to which you have two dimensions joining, say managers and customers,...

To get around this particular issue I think I would always write to a standard file of the same name then rename the new file to what ever it is...

Thanks Noel,

Is there anymore info you can give me on this... are you talking about the SQL Server resourse kit? Do you have a URL that explains in more detail?

Cheers

R

No you will be running the lastest version of the package by default if you execute it from with Enterprise Manager.

Sounds fishy to me.... if you save the package, close...

In reality this is not an AS issue. It simply comes down to duplicates in your data that would affect any application using this information.

As stevefromOZ rightly points out "If...

How are you executing the DTS package?? Each time you make an amendment to a package and save it, another version of that DTS package is created. If you are...

This is a really great use of data in the sys tables of your database, especially when it comes to providing documentation.

One small bug in the procedure however is that...

Once again.... I agree.... whether you access it directly or indirectly, the only way you can determine if a block exists is by querying the sysprocessors table!