Great, thanks guys.

Very interested to see the recursive CTE solution as that is what I've been trying to get going most of this morning! I wasn't far...

Henry B. Stinson (4/26/2012)

---

I saw a very clever use of ROW_NUMBER( ) OVER (ORDER BY CASE WHEN ....) as RowNum,

in a CTE WITH-clause in a stored proc, where the CASE...

Are you familiar with Scott Ambler's website, worth a look if you want to find out more about Agile data.

http://www.agiledata.org/

I ran an Agile BI project and it seemed...

Well, as a BI developer, I am used to using 3rd party products as a data source.

But generally we'll munge the data into a more useful form via...

unless you have millions of dabases to loop through... what's wrong with a cursor?

It's always better to understand why cursors aren't optimal and then you can decide if it...

It might prove cost effective to talk to an experienced designer as you might find this saves you much effort in the long run.

At the least have a read of...

You might find the answer here.

😉

I haven't done it myself, but I guess you could also dynamically configure the name if executing reports with rs.exe

I learnt the hard way that importing existing packages was no short cut. By the time it was all up and running I wished we had rebuilt everything from...

A good example of something that would be better solved through education. The cost in usability and complication just doesn't seem worth it. The time sorting out the...

Agreed, having worked on a system where someone decided to implement checksums to manage change control I know from bitter experience that it will bite you at some point. ...

I always like a query that gets down and dirty with system tables ;)! Nice. But I'm not sure occasionally cursoring through a few hundred tables is really...

ProClarity 6.3 too. Still seems on top but interested to see what MS do with it next!

boudewijn.lutgerink (8/12/2008)

---

Take a look at Stonefield Query, a powerful application to extract intelligent...