Reply to Re: SQL stored procedure returns duplicates

Your name:

Reply:


Posted by Ed Murphy on 03/24/07 02:05

yin_n_yang74@yahoo.com wrote:

> I am new to SQL and SQL Server world. There must be a simple solution
> to this, but I'm not seeing it. I am trying to create a crystal
> report (v8.5) using a stored procedure from SQL Server (v2000) in
> order to report from two databases and to enable parameters.
>
> When I create the stored procedure, it joins multiple one-to-many
> relationship tables. This results in repeated/duplicate records. Is
> this an issue that should be solved within the stored procedure, or is
> this inevitable? If latter, how do you eliminate the duplicates in
> Crystal Reports?

Never mind the stored procedure, have Crystal read the tables
directly: Event from the main report, Food from a subreport,
Equipment from a second subreport. Pass the primary key of
Event to each subreport as a parameter, linking it to the
appropriate foreign key within the subreport.

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация