I want a stored procedure that retrieves ID and PID from the invoice table with batchid as input parameter and based on the retrieved PID I want to retrieve sid from the log table.
In total I want to retrieve 3 parameters – ID, PID and SID

I have written SP below but I think this can be optimized

CREATE OR ALTER PROCEDURE INVOICE_IDS(@BATCHID INT)
AS
BEGIN

SELECT ID, PID
FROM INVOICE where BATCHID =@BATCHID AND ISACTIVE=1 AND LINEID = 1;

SELECT SID FROM LOG WHERE STATUSID = 23 AND RELATEDENTITYID in ( SELECT PID
FROM INVOICE where BATCHID =@BATCHID AND ISACTIVE=1 AND LINEID = 1) AND RELATEDENTITYTYPEID = 13 AND ISACTIVE = 1;

END