Including Additional Table Count in Existing Process

Transact-SQL
1

Hello,

I want to include the total count of a new/additional Table X as part of just the 'Members Loaded' value so that it would be part of the existing 'LOAD_CNT', 'DIFF' and 'PCT' values. Is that possible?

SELECT LOAD_DT = LOAD_DT,
       SOURCE_CNT = SourceFileMemberCount, 
       LOAD_CNT = MembersLoaded,
       DIFF = SourceFileMemberCount - MembersLoaded,
       PCT = CAST(CAST(100
                       * ((SourceFileMemberCount - MembersLoaded) / (CAST(SourceFileMemberCount AS DECIMAL(18, 2)))) AS DECIMAL(18, 2)) AS VARCHAR(8))
             + '%',
       SourceFileName = SourceFileName
FROM tblLoadInformation
WHERE LOAD_DT = CONVERT(VARCHAR(10), GETDATE(), 101);

Thank you.

2 

SELECT LOAD_DT = LOAD_DT,
       SOURCE_CNT = SourceFileMemberCount, 
       LOAD_CNT = MembersLoaded,
       DIFF = SourceFileMemberCount - MembersLoaded,
       PCT = CAST(CAST(100
                       * ((SourceFileMemberCount - MembersLoaded) / (CAST(SourceFileMemberCount AS DECIMAL(18, 2)))) AS DECIMAL(18, 2)) AS VARCHAR(8))
             + '%',
       SourceFileName = SourceFileName,
       (SELECT SUM(p.rows) FROM sys.partitions p WHERE p.object_id = OBJECT_ID('tblLoadInformation') 
            AND p.index_id = 1) AS row_count
FROM tblLoadInformation
WHERE LOAD_DT = CAST(GETDATE() AS date)