You can alter the SP to pass parameter(s) indicating which results you want. E.g.
ALTER PROCEDURE [dbo].[SPGetDate]
@Param1 int,
@Param2 int,
@Param3 int
AS
BEGIN
IF @Param1 = 1
SELECT * from tblAVAA;
IF @Param2 = 1
SELECT * from tblKit;
IF @Param3 = 1
SELECT GETDATE();
END
GO
called like this
exec [dbo].[SPGetDate] 0,1,0
Or you could have a single parameter and use bitwise comparison e.g.
ALTER PROCEDURE [dbo].[SPGetDate]
@Param1 int
AS
BEGIN
IF @Param1 & 1 = 1
SELECT * from tblAVAA;
IF @Param1 & 2 = 2
SELECT * from tblKit;
IF @Param1 & 4 = 4
SELECT GETDATE();
END
GO
which could be called like this (note the variables are just to make it obvious which resultsets are required)
declare @RS1 int = 1
declare @RS2 int = 2
declare @RS3 int = 4
exec [dbo].[SPGetDate] @rs2
or
declare @reports int = @RS1 + @RS3
exec [dbo].[SPGetDate] @reports
Alternatively just discard the other data in your other SP