Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL database design

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-11-14 : 11:29:43
Seema writes "I am building an application that takes fr user the following input
1. IP Address of Host machines(as many as user wants to enter)
2. The name of component he wants to install
3. The name of subcomponents

and finally add the complete information to one single table when user clicks submit.
The application is build in java and i am using SQL tables.
for example: if user says that for three machine he wants to install SQL Server and .net which are database and develompment components resp. and when user clicks "SUBMIT", six rows shd be written to my final table
host1 database SQL Server
host1 development .Net
host2 database SQL Server
host2 development .Net
host3 database SQL Server
host3 development .Net

how shd i do this select from three tables and insert into final table."
   

- Advertisement -