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

Is it possible to create trigger on views?

1034

---

difference between Clustered index and non clustered index ?

1039

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

979

---

What are the new security features added in sql server 2012? : sql server security

1110

---

What is filestream?

1052

---

Where the sql logs gets stored? : sql server database administration

1015

---

Does an index slow down updates on indexed columns?

1040

---

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

961

---

What is tempdb in sql server?

1031

---

What is scalar user-defined function?

1192

---

What is normalization process?

1244

---

Tell me the difference between clustered and non-clustered index?

994

---

How to create and drop temp table in sql server?

1102

---

What are the security related catalog views? : sql server security

994

---

What is primary key index?

1019

---