Fetch Multiple records from Database

Create Procedure [dbo].[Test]
@Flg1 bit,
@Flg2 bit,
@Flg3 bit,

AS
BEGIN
SET NOCOUNT ON;

Declare @Query varchar(max)

if(@Flg1<>0)
Begin
Set @Query='Select * from emplayee where empId=1'
End

if(@Flg2<>0)
Begin
Set @Query=@Query+'and empId=2'
End

if(@Flg3<>0)
Begin
Set @Query=@Query+'and empId=3'
End

Exec sp_executesql(@Query);

End