SQL Server 2000 SP want to use single Stored procedure to return different types of SQL Queries
===

I've limitation to work on SQL 2000 on a very big project. For one Module I've to create 3 to 10 Stored procedures. To Make it manageable I'm writing one Stored Procedure to return different SQL queries based on condition like:

    If @QueryId = 'SelAllEmp'
       Select EmpId,EmpName from EMP 
    ELSE IF  @QueryId = 'SelEmpById'
       Select EmpId,EmpName from EMP where EmpId= @EmpId
    ELSE IF @QueryId = 'EMPDept'
       Select EmpId, DeptId, DeptName from EMPDept
    ......................................

My Question is, Are there any hidden consequences or impacts using this technique?


