better sp to get details for related to that perticular id?

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go









ALTER PROCEDURE [dbo].[usp_RptSalesSummary]
--@UserGroupID int,
@CompanyID int=null,
@PartyName varchar(50)=null,
@DateFrom datetime=null,
@DateTo datetime=null
AS BEGIN
if @CompanyID is null 
Begin
SELECT  tblStockDetails.*,tblStockHeader.*,tblCompanyMaster.*
FROM
tblStockDetails
INNER JOIN
tblStockHeader ON tblStockDetails.sdDID = tblStockHeader.shDID AND 
tblStockDetails.sdDocType = tblStockHeader.shDocType

left outer join tblCompanyMaster on tblStockHeader.shPartyID=tblCompanyMaster.cmCompanyID
WHERE (@DateFrom IS NULL OR
tblStockHeader.shDocumentDateTime >= @DateFrom) AND (@DateTo IS NULL OR
tblStockHeader.shDocumentDateTime <= @DateTo)

AND tblStockHeader.shIsDelete=0
ORDER BY tblStockHeader.shDocumentDateTime

End else if @CompanyID is not null 
Begin
SELECT tblStockDetails.*,tblStockHeader.*,tblCompanyMaster.*
FROM
tblStockHeader
INNER JOIN
tblStockDetails ON tblStockHeader.shDID = tblStockDetails.sdDID AND
tblStockHeader.shDocType = tblStockDetails.sdDocType
 left outer join tblCompanyMaster on tblStockHeader.shPartyID=tblCompanyMaster.cmCompanyID 


WHERE 
tblStockHeader.shIsDelete=0
ORDER BY tblStockHeader.shDocumentDateTime

End
END