Answer / soorai ganesh

create table emp (eid int, ename varchar(50),mid int)

insert into emp values(1,'Ganesh',null)
insert into emp values(2,'Ramesh',1)
insert into emp values(3,'Suresh',1)
insert into emp values(4,'Selvam',2)
insert into emp values(5,'Vignesh',3)

select * from emp

Declare @eid int
Set @eid = 4 -- Your Input ID here..

Select 'Manager For '+CONVERT(VARCHAR,emp2.eid)+' --> '+ emp1.ename
From emp emp1
Inner join emp emp2 on emp1.eid = emp2.mid and emp2.eid = @eid

Answer / samba shiva reddy . m

select emp.ename from employee emp1
inner join employee emp
on emp1.mid=emp.eid
where emp1.eid=102

Answer / saravanan p

Declare @eid int
Set @eid=2

select 'The manager for employee id '+convert(varchar
(50),e2.eid)+' is '+e1.ename from emp e1,emp e2
where e1.eid=e2.mid and e2.eid=@eid

Answer / mohana krishna

create table #emp (eid int, ename varchar(50),mid int)

insert into #emp values(1,'Ganesh',null)
insert into #emp values(2,'Ramesh',1)
insert into #emp values(3,'Suresh',1)
insert into #emp values(4,'Selvam',2)
insert into #emp values(5,'Vignesh',3)

declare @aid int
set @aid =1
select ename from #emp
where eid = (select case isnull(mid,0) when 0 then eid
else mid end mid
from #emp
where eid=@aid
)


select m.ename from #emp e
join #emp m on (m.eid=isnull(e.mid,e.eid))
where e.eid=1

Answer / suraj

-- create table #Employees (EID int, EName varchar(20), MID
int)
-- insert #Employees values(101,'Rama',NULL)
-- insert #Employees values(102,'Sita',101)
-- insert #Employees values(103,'Shiva',101)
-- insert #Employees values(104,'Ganesh',103)

--for 103 ID the manager ID is 101(RAMA) and for 104
manager is SIVA
--Write a script which displays Shiva's Manager's name.

select a.EID, a.EName, a.MID, b.EName
from #Employees a
inner join #Employees b on a.mid=b.eid and a.EName='Shiva'

Answer / samba shiva reddy . m

this will also works for u change is id in inner join

select emp1.ename from employee emp1
inner join employee emp
on emp1.eid=emp.mid
where emp.eid=102

Answer / mohana krishna

select ename from employee
where eid = (select case mid when null then aid
else mid end mid
where eid=@aid
)


select m.name from employee e
join employee m on (m.aid=e.mid)

How to select some specific columns from a table in a query in ms sql server?

0 Answers  

What are binary string data types in ms sql server?

0 Answers  

What security features are available for stored procedure?

0 Answers  

how many layers of tcp/ip protocol combined of? : Sql server database administration

0 Answers  

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 Answers  

What is coalesce and check constraint in sql server?

0 Answers  

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 Answers  

What is conditional split?

0 Answers  

What are the steps to insert a table?

0 Answers  

Give me a SQL Query to find out the second largest company?

0 Answers   Ernst Young,

Why is normalisation important?

0 Answers  

What options are available to audit login activity? : sql server security

0 Answers