how to display extra department name with department id in stored tab

Bhavesh Vankar

4y837

i have below sql query wich is display department name i combobox from table. but i want to display some more department name but don't want to store that department name in table.

i have done it but when i try to add more than one name it generate error... kindly help me what should i do...?

i have display one department without store in table is

10000 OTHER

Now i want to display more department name without store in table

10001 OTHER 2

10003 OTHER 3

10004 OTHER 4

SELECT EMP_MASTER.DEPTID,DEPTNAME FROM EMP_MASTER INNER JOIN 
dept_cmp_master ON dept_cmp.deptid=EMP_MASTER.DEPTID WHERE dept_emp.emp_flg='p' 
Union SELECT  10000,'OTHER' as DEPTNAME from EMP_MASTER ORDER BY EMP_MASTER.DEPTNAME ASC

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bhavesh Vankar4y ago
is this possible without create table ?

abouve query is working fine but i need to add more department now...using this query can possible with some modification.?
+1
Sachin Singh4y ago
Create Temp table and join
Create Table #myTable (DEPTID int, DEPTNAME nvarchar(50))
Insert into #myTable Values (10000 ,'OTHER')
Insert into #myTable Values (10001 ,'OTHER 2');
Insert into #myTable Values (10003 ,'OTHER 3');
Insert into #myTable Values (10004 ,'OTHER 4');

Create Table #table2(DEPTID int, DEPTNAME nvarchar(50))


SELECT EMP_MASTER.DEPTID,DEPTNAME FROM EMP_MASTER INNER JOIN dept_cmp_master ON dept_cmp.deptid=EMP_MASTER.DEPTID into #table2
WHERE dept_emp.emp_flg='p' ORDER BY EMP_MASTER.DEPTNAME ASC

SELECT * FROM #myTable UNION SELECT * FROM #Table2
+1