[AccessD] OT SQL Question

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 <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¢
> -- 
> _______________________________________________
> 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


----------------------