
MS SQL Server Stored Procedures
Thanks for that.
Am I correct in thinking from this example that you can only have one select
statement or set of results in a stored procedure used by Crystal Reports ?
I'd also like to have multiple select statements from different tables that
are unrelated, in a procedure.
Using
select...
select...
select...
only makes the fields from the first statement available.
Will I have to build a temporary table that contains all the required
fields. This could be difficult as there may be a one to many relationship
with some of the data. E.g. My report could have a standard header that only
requires one record from the database but the details section could contain
several records.