Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sajis79
Starting Member
3 Posts |
 Posted - 2005-05-25 : 00:47:01
|
| -- TABLE STRUCTURE --CREATE TABLE EMP ( EMPID INT NOT NULL, EMPNAME NVARCHAR(15),SUPID INT)-- VALUES --INSERT INTO EMP VALUES(100,'ADMIN',NULL)INSERT INTO EMP VALUES(101,'HARI',100)INSERT INTO EMP VALUES(102,'BALAJI',100)INSERT INTO EMP VALUES(103,'SANTOSH',101)INSERT INTO EMP VALUES(104,'SAJI',103)INSERT INTO EMP VALUES(105,'NIRMAL',103)INSERT INTO EMP VALUES(106,'PRAVEEN',102)INSERT INTO EMP VALUES(107,'BASKAR',106)INSERT INTO EMP VALUES(108,'SHIVA',101)COMMENTS -SUPID IS THE SUPERIOR IDI NEED A PROCEDURE WHERE IF I PASS A PARAMETER EMPID IT SHOULD DISPLAY ALL THE SUBORDINATES UNDER THAT EMPID--EXAMPLE 1--EXECUTE PROCEDURE 103SHOULD RETURN103 SANTOSH 101104 SAJI 103105 NIRMAL 103--EXAMPLE 2--EXECUTE PROCEDURE 101SHOULD RETURN101 HARI 100103 SANTOSH 101104 SAJI 103105 NIRMAL 103108 SHIVA 101AND IF I PASS 100 ALL UNDER 100 SHOULD BE DISPLAYEDEMPID WILL NOT BE ANY NUMBER IN ANY ORDER IN THE TABLE NOT THE ONE SHOWN ABOVEURJENT PLEASETHANKS IN ADVANCESAJI S. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
|
|
sajis79
Starting Member
3 Posts |
Posted - 2005-05-25 : 01:18:12
|
| HAI derrickleggett THANKS FOR REPLYINGTHE LINK WHAT YOU GAVE COULD GIVE ME IMMEDIATE BOSS OR BIG BOSS OF BOSS. IF I WANT TO GET NTH LEVEL I NEED TO ALTER THE TABLE STRUCTUREIS THERE ANY OTHER METHOD RECURSIVE FUNCTION/PROCEDURE SO THAT MY PURPOSE IS SERVERD WITHOUT ALTERING TABLE STRUCTURETHANKS IN ADVANCESAJI S. |
 |
|
|
|
|
|
|
|
Recursive procedure