drop table #result

drop table #Employee

drop table #Empdept

drop table #Department

create table #result(emp_id int, all_dept_desc varchar(500))

create table #Employee(emp_id int, emp_name varchar(10))

insert into #Employee(emp_id, emp_name) values (1, 'John')

insert into #Employee(emp_id, emp_name) values (2,...