Viewing 15 posts - 17,971 through 17,985 (of 19,564 total)
Jeff Moden (1/20/2010)
January 21, 2010 at 10:26 pm
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.
January 21, 2010 at 10:13 pm
Thanks for the question. It was a pleasure to answer it.
January 21, 2010 at 10:10 pm
Jeff Moden (1/21/2010)
Very cool code and a great link, Jason. Thanks!
Thanks for the compliment and you're welcome.
January 21, 2010 at 10:06 pm
A good hardy laugh is also very useful in keeping the stress at bay.
January 21, 2010 at 10:04 pm
No downtime required.
January 21, 2010 at 6:19 pm
you're welcome
January 21, 2010 at 5:48 pm
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...
January 21, 2010 at 5:47 pm
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...
January 21, 2010 at 5:42 pm
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.
January 21, 2010 at 5:29 pm
canoedoceanprince (1/21/2010)
I have no idea creating a CTE recursive query in SSRS. 🙁
I apologize - I did not check the forum heading. Are you running SQL 2005 or SQL...
January 21, 2010 at 5:27 pm
You might want to look into doing a recursive CTE
January 21, 2010 at 5:03 pm
RD-201664 (1/20/2010)
January 21, 2010 at 4:51 pm
One more nod in agreement with Lowell and Lobbymuncher
January 21, 2010 at 4:38 pm
Viewing 15 posts - 17,971 through 17,985 (of 19,564 total)