S D
accessd667 at yahoo.com
Fri Apr 23 03:45:37 CDT 2004
Martin, can you please provide a little more info? WHY do you not want to use cursors? Where does the output have to go to? What format does it need to have? What's the layout of the tables? (Send me the create table scripts...) Sander Martin Reid <mwp.reid at qub.ac.uk> wrote: Tried the SQL Server list with this - no luck. Given a one to many relationship is it possible to produce this output using an SP without the use of cursors etc?? INPUT TABLE 1 1000 IT 1000 Databases 1000 VMS 1001 Spreadsheets 1001 GenStat 1002 Aquatic systems 1002 Research INPUT TABLE 2 1000 Smith 1001 Brown 1002 Foster OUTPUT REQUIRED 1000 Smith IT, Databases,VMS 1001 Brown Spreadsheets,GenStat 1002 Foster Aquatic Systems,Research Martin -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com --------------------------------- Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢