Suppose in a situation if two list boxes are there and if
you select multiple options based on that the options
related to those selected items should display in second
list box.

Again if we select multiple items in second listbox then the
related to those selected items should display .

In this scenario how will you design database,tables?

Suppose in a situation if two list boxes are there and if you select multiple options based on that..

Answer / pawan k. dubey

e.g. create two table
1-department(dept_id int PK,dept_name)
2-employee(emp_id int Primary key,Name varchar(40),dept_id

now create two listbox employee and department.

step1-when multiple departments are selected...dispaly
employee related to selected department in employee listbox

step2-when multiple employees are selected...dispaly
respective department in department listbox

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More SQL Server Interview Questions

Explain the basic concepts of SQL server architecture?

2 Answers   College School Exams Tests,

After the SQL installation what are the jobs will you configure?

1 Answers   IBM, Satyam, G7 CR Technologies,

Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance

10 Answers   IBM,

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

What types of integrity are enforced by a foreign-key constraint

1 Answers  

Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

query processing

0 Answers  

How to get number of days in a given year?

4 Answers   ADP,

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

Difference between writing SQL query and stored procedure ?

15 Answers   TCS, Infosys, Cognizant, Veritas,

1.How to check the backup file details if we do not have access to that folder to check the backup file size without connecting to the folder

3 Answers   IBM, CarrizalSoft Technologies,