Thanks guys, I knew it would be something simple.

Jack,

I just tested out the CTE and it does work when MY_TABLE_HISTORY has just one value for sNane or 1 table name. The problem is getting the first &...

I have not but I will; thanks Jack!

Jack Corbett (12/22/2009)

---

If you are using the current version of the script you should be getting data from ALL the trace files. The T.path column will only return the...

@Gianluca Sartori

I did have a question about this probelm with Crystal Reports; do you know for certain which versions of Crystal (starting with 9 and going up) suffer from this...

Gianluca Sartori (8/18/2009)

---

In fact this is one of the weaknesses of this strategy.

There's no technical solution to this issue: when a user wants to display a 1 mln rows...

Jeffrey Williams-493691 (12/21/2009)

---

First, I don't believe SQL Server actually stores login attempts. You can find that information in the event log and/or SQL Server log.

Second, the only way the...

Ron - This article/post referenced by Gianluca details exactly the process I was trying to describe;...

Jack,

I just re-discovered this script, something I used a while back and I've hit an odd snag. Last time I see I posted that when i ran it I...

Ron,

Something to consider with your scenario is changing your data source from using a STORED PROCEDURE to using a table. I say this for a couple of reasons. ...

Thanks for the sample Deepforest but I was hpoing you'd drop in something a little more flexable like a select from one of the sample MS DBs, something like this

INSERT...

Dumb question but could you provide an example of populating the TREE table? I believe i am following the TREE tables design but it would be nice to see...

Thanks Lynn. If I happen to stumble across the answer before then I'll post back again.

Lynn,

Looks like I still need help after all. The article by Jeff Modem is I think over kill for what I am looking for. I'm not doing any kind...

Lynn Pettis (12/16/2009)

---

YSLGuru (12/16/2009)

---

Drew,

Thanks for replying and I know this is a few months old now (Just now getting time to go back and deal with this one) but unfortunately...