Answer Posted / ankit nanda

Do onething
just create a function which use the three input parameters
and
while select * from ComputeEmployee(,,,)insert one of the
designation or salary or department at a time or wtever u
want....here i used some case statement to solve the
problem..wheeeeww...one thing else uniqueidentifier i just
use for the column type,u can use a simple int also ::))


create function ComputeEmployee(@Designation nvarchar
(100),@Department nvarchar(100),@Salary bigint)
returns @DemoTable table (EmployeeID
uniqueidentifier,Designation Nvarchar(100),Name Nvarchar
(100),Department Nvarchar(100),Salary bigint)
as
begin
insert into @DemoTable
select
ed.EmployeeID,ed.Designation,ed.Name,sd.Department,sd.Salary
from EmployeeDetails ed inner join
SalaryDetails sd on sd.SalaryID=ed.EmployeeID
where ed.Designation like case when
@Designation IS not null then '%'+@Designation+'%' end
AND sd.Department like case when
@Department IS not null then '%'+@Department+'%' end
AND sd.Salary =case when @Salary Is not
null then @Salary else sd.Salary end
return
end

Where are sql server usernames and passwords stored in the sql server?

613

---

What are the different ways you can create databases in sql server?

571

---

application server is slow what may be the problem

1784

---

What are subqueries in sql server? Explain its properties.

545

---

What is the usage of sign function?

593

---

---

What are the differences between clustered and non-clustered index?

539

---

What is a file group?

622

---

What is a database table?

523

---

What is an index in sql?

552

---

What is save transaction and save point?

622

---

What is the partitioning method?

530

---

what are acid properties? : Sql server database administration

495

---

What is meant by referential integrity?

591

---

What is history table in sql server?

506

---

Are all views updatable ?

727

---