S D
accessd667 at yahoo.com
Mon Apr 26 00:22:49 CDT 2004
Martin, I've checked it out during the weekend (for a short while...it IS a weekend he). I don't see how you could create this using SQL. PERHAPS, using COMPUTE?! I'm not very familiar with this keyword. To save a lot of time and (very) complex coding...just use a cursur. Add each value to a variable and use this in an insert statement. Regards, Sander PS: Oracle to retrieve SQL-Server data....oi Martin Reid <mwp.reid at queens-belfast.ac.uk> wrote: Sander See inline Martin > Martin, > > can you please provide a little more info? > WHY do you not want to use cursors? No reason just wanted to try it using SQL but didnt seem possible without cursors. > Where does the output have to go to? Into a table > What format does it need to have? see above > What's the layout of the tables? (Send me the create table scripts...) No problem will email them of line later on. That OK? > > Sander > > Martin Reid 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¢ > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com Martin WP Reid Information Services Queens University Belfast Tel: (02890) 273750 ---------------------- -- _______________________________________________ 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¢