>
> Could you please help me out how to return two table values in FireBird
> as in sp we have only one returns statement.
>
> Example in SQL - Select * from employee
> Select * from Department
>
> It returns in two table in sql server 2008
>
>

As I know, stored procedures in Firebird have a fixed result set. May be you can imitate this behaviour with temporary tables?

What is the purpose, advantage to have 2 result sets: Easy porting? Parallel SQL execution on server?

Maybe you can add a "magic" layer in your application that calls two different stored procedures with the desired result sets?