Recent content by SkidsMcCoy

That's really helpful - thanks. For packages only involving SQL Server databases, that works fine now. I still have a problem with my data warehouse, though. When I create the DTS package, the connection options are based on my client PC's ODBC settings - and when I run the package via SQL...

Hi, We've just introduced an implementation of SQL Server to use as an adjunct to our data warehouse - the idea is we set up data marts as required, when we need a more flexible 'sandpit' environment to work with large volumes of data. So far, this is working fine except for one thing - when...

It's an interesting question. And as a reformed philosopher, I have to ask what is meant by 'legitimate'. It's a internally consistent system that can be used to model events in the real world. How could this be less legitimate than mathematics or binary logic?

Hi Guys - new poster here. Enjoying the archives but can't find a solution to this problem. I have a list of customers and transactions, and need to band them into 5 percentiles. Let's say there a million customers - I need to know the bandings for the top 200,000, the next 200,000 etc. These...