Gordo et al,

Another option is to not generate the html file - just generate the xml file, which itself contains a reference to the xsl stylesheet. You can then...

Firstly, I couldn't get the code to run from the article - as it's different from the code in the resource section!

But more importantly I think you're missing the point...

mdonnelly (2/27/2009)

---

This would have been on the bubble of being excusable had the original article not had a...

or even an ascent article! (no s in decent.)

Nice article - nothing revolutionary, just good relevant practical advice on making life easier. Look forward to the next installments.

David McKinney.

Afterthought, if the proc is taking too long, perhaps you should be focusing on the indexes on the tables rather than the proc itself!

I would assume that in the majority of cases you will not be creating a new page - you will just be inserting into the tbl_Tracking_dtl.

For that reason, it would...

Jack Corbett (2/24/2009)

---

I'd start with something like this:

IF NOT EXISTS(SELECT 1 FROM dbo.tbl_Tracking_WebPages WHERE Page_Name = @Page_Name)

BEGIN ...

mishaluba (1/29/2009)

---

Absolutely loved the article. I am sure everyone had to do something like this at one time or another. Thank you for sharing this technique and nice...

Thanks, Paul. ...

....found it!

EXEC master..xp_dirtree 'C:\temp',@depth, @includefiles

e.g. EXEC master..xp_dirtree 'C:\temp',1,1

Hi Jeff,

Does this really work for getting...

Dave R (1/30/2009)

---

Good article. I tried to use it to get results of calculations for previous year and quarter but not working.

How can I use your example "Linking to...

OK...I get you. I immediately thought more of 'script generation' i.e. Create Table...

Ninja's_RGR'us (1/28/2009)

---

I was subscribed to this thread as well. And Jeff only replied to it because someone else posted another solution a couple minutes before him.

When replying to a...