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

Define normalisation?

1114

---

What is isolation levels?

1029

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1140

---

What is after dml trigger?

1016

---

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

929

---

What is tablesample?

1110

---

What is difference between delete and truncate commands?

1081

---

What are indexes in sql?

1281

---

What is index fragmentation in ms sql server?

1082

---

Tell me about builtinadministrator?

1001

---

How global temporary tables are represented and its scope?

975

---

What are the difference between “where” and “having” clause in sql server?

1069

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2071

---

How to get the query of a table in sql server?

898

---

Why people hate cursor?

1145

---