Jeff Moden (1/20/2010)

---

... I also give a couple of simple problems to do with access to the Developer's Edition, Books Online, and whatever they can scare up on the web....

Community college and clep your way through most of the credits - could get a lot of degree for that:-D

MIT - you might get a few semesters.

Thanks for the question. It was a pleasure to answer it.

Thanks for the compliment and you're welcome.

A good hardy laugh is also very useful in keeping the stress at bay.

You're welcome

No downtime required.

you're welcome

No downside, but you will need to get a full backup and configure t-log backups. If you don't start backing up the t-logs - they will grow and can...

If you follow the link in my first reply it will give you an overview of how to write a Recursive CTE. This is used to produce Hierarchies.

Now if...

Here is a SQL 2000 friendly suggestion:

http://www.sqlteam.com/article/more-trees-hierarchies-in-sql

As for building the queries, I would create a stored procedure and then have your report use the stored proc.

I apologize - I did not check the forum heading. Are you running SQL 2005 or SQL...

You might want to look into doing a recursive CTE

http://msdn.microsoft.com/en-us/library/ms186243.aspx

RD-201664 (1/20/2010)

---

I have a development laptop with a Windows XP sp3 and a 300GB drive partitioned into 2 parts. Drive C: is 150GB and contains the Windows OS, program...

One more nod in agreement with Lowell and Lobbymuncher