Ask the Expert

Stored procedures in Crystal Reports

I am fairly new to SQL server and I need to create many (probably 50+) stored procedures. These stored procedures will be used by Crystal reports within an application. An application consultant explained a little about stored procedures to me, but I need to improve my skills before I will be able to perform this task. I have a fair amount of experience query writing with Access and VBA, and understand relational databases. Any suggestions on a few good books about stored procedures and possibly courses (in the Toronto, Canada) would be appreciated.

    Requires Free Membership to View

The book on stored procedures that I like the most is Advanced T-SQL for SQL Server 2000 by Itzak Ben-Gan and Tom Moreau. It has everything you're going to need to write reporting stored procedures. Another great book on advanced SQL topics, not specific to SQL Server is Joe Cleko's SQL for Smarties.


Do you have comments on this Ask the Expert Q&A? Let us know.

This was first published in September 2005

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: