Re: Promt user for criteria ?

On Thu, 26 Jan 2006 18:31:01 -0800, Xavier wrote:

>Hugo
>
>Thank you, based on your experience with SQL can you recommend
>and good books on SP and queries within sql.

Hi Xavier,

I've learnt most from Books Online and by trial and error. But I'll give
you some titles that are often recommended in these groups by very
kowledgeable persons.

Two books specifically targetted towards coding for SQL Server:
* Advanced Transact-SQL for SQL Server 2000 (Ben-Gan/Moreau)
* The Guru's Guide to Transact-SQL (Henderson)

A book about the inner working of SQL Server - a great aid if you start
to think about fine-tuning, since knowing how things work is the best
way to tune:
* Inside SQL Server 2000 (Delaney)

An advanced book, full with tips and tricks. Definitely no easy stuff
here. And it uses ANSI standard SQL - you'll have to change some things
here and there to amke it run on SQL Server:
* SQL for Smarties (Celko)

>
>We are planning on moving from access as a front end reporting tool and
>replacing it with Crystal Reports, any thoughts on this you might want to
>share?

I've never worked with Crystal Reports.

--
Hugo Kornelis, SQL Server MVP
.

Relevant Pages

  • Re: Access using SQL Server only DB
    ... I recommend you re-write that report to use a SQL Pass Through Query so you ... It all works except for one report. ... > of creating such a relationship i SQL Server! ...
    (microsoft.public.access.externaldata)
  • Re: Crosstab REPORT, not query
    ... you can use the 'Database Tuning Advisor' against the SQL ... other books on ADP? ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Follow up query from Fresher - Aaron Bertrand
    ... Start with Database Design for Mere Mortals, ... SAMS books, ... administration, then Inside SQL Server ...
    (microsoft.public.sqlserver.programming)
  • Re: IF statement in SQL?
    ... On Fri, 11 Nov 2005 18:45:18 GMT, bakedmike via SQLMonster.com wrote: ... and outs of SQL by trial, ... A very basic entry-level SQL book (not specific for SQL Server, ... The following two books are medium-level books that ARE specific for SQL ...
    (microsoft.public.sqlserver.mseq)
  • Re: SQL Server in SBS2000
    ... There are a couple of other "For Dummies" books on MS SQL. ... SQL is just the database backend. ... This would tell us how many calls the agent is taking (ie: ...
    (microsoft.public.backoffice.smallbiz2000)