Good IT companies at ahmedabad / gandhingar

Here I am giving some list of IT companies at ahmedabad / gandhinagar in which working will be really beneficial for software engineer. The view is of mine personal only. I am listing name of the companies in which I have worked,had given interview or heard from authenticated sources. There are also many companies in which you should not go. But I am not listing it here if you are selected in any company not listed here and want to know about it you can feel free to contact me.

1. Cybage Software Pvt. Ltd.
2. iGATE Patni
3. TCS
4. IMany
5. Cygnet Infotech Pvt Ltd.
6. Clarion Technologies
7. INDUSA Technical Corp
8. TatvaSoft
9. Avani Cimcon Technologies Inc
10.Elitecore Technologies Pvt. Ltd.
11.SNL Financial


I'll continue adding names of the company of which I will get some authenticated information from authenticated sources.

Get Team Members of A Supervisor

/*

      Suppose you have table Employees as shown below

      EmployeeID  FirstName   LastName    ReportsTo

      1           Nancy       Davolio     2

      2           Andrew      Fuller      NULL

      3           Janet       Leverling   2

      4           Margaret    Peacock     2

      5           Steven      Buchanan    2

      6           Michael     Suyama      5

      7           Robert      King        5

      8           Laura       Callahan    2

      9           Anne        Dodsworth   5

      and you want to find employes to whom Steven Buchanan supervise

      you can use below query to retrieve the required list

*/

 

--Get Team Members of A Supervisor

 

Declare @EmployeeID Int

Set @EmployeeID = 5

 

;WITH GetEmployee(EmployeeId,EmpName)

      AS (

      Select EmployeeId,FirstName + ' ' + LastName as  EmpName

      From Employees  E

      Where EmployeeId=@EmployeeID

 

     

      UNION ALL

 

      Select E.EmployeeId,FirstName + ' ' + LastName as  EmpName

      From Employees  E,GetEmployee G

      Where E.ReportsTo =G.EmployeeId

    )

 

Select *

From GetEmployee