SELECT e.ireadinwith                              AS isourceid,
       '1'                                        iSP,
       'SP'                                       sSP,
       CONVERT (VARCHAR, dtransferstartdate, 101) dTransferDate,
       (SELECT Count(efiletype)
        FROM   svintermediatefilestore.dbo.filetransfer d
        WHERE  d.efiletype IN( 129 )
               AND d.ireadinwith = e.ireadinwith
               AND d.guserid IN ( e.guserid ))    AS DCefiletype,
       (SELECT Count(efiletype)
        FROM   svintermediatefilestore.dbo.filetransfer d
        WHERE  d.efiletype IN( 130 )
               AND d.ireadinwith = e.ireadinwith
               AND d.guserid IN ( e.guserid ))    AS VUefiletype,
       (SELECT Count(efiletype)
        FROM   svintermediatefilestore.dbo.filetransfer d
        WHERE  d.efiletype IN( 131 )
               AND d.ireadinwith = e.ireadinwith
               AND d.guserid IN ( e.guserid ))    AS VDOefiletype,
       (SELECT Sum(CONVERT(DECIMAL, loriginalfilesize)) / 1048576
        FROM   svintermediatefilestore.dbo.filetransfer d
        WHERE  d.efiletype IN( 128, 129 )
               AND d.ireadinwith = e.ireadinwith
               AND d.guserid IN ( e.guserid ))    AS DClFileSize,
       (SELECT Sum(CONVERT(DECIMAL, loriginalfilesize)) / 1048576
        FROM   svintermediatefilestore.dbo.filetransfer d
        WHERE  d.efiletype IN( 130 )
               AND d.ireadinwith = e.ireadinwith
               AND d.guserid IN ( e.guserid ))    AS VUlFileSize,
       (SELECT Sum(CONVERT(DECIMAL, loriginalfilesize)) / 1048576
        FROM   svintermediatefilestore.dbo.filetransfer d
        WHERE  d.efiletype IN( 131 )
               AND d.ireadinwith = e.ireadinwith
               AND d.guserid IN ( e.guserid ))    AS VDOlFileSize
FROM   svintermediatefilestore.dbo.filetransfer e,
       invoiceorganisation SP
WHERE  e.guserid IN (SELECT guserid
                     FROM   users
                     WHERE  laccountid IN (SELECT laccountid
                                           FROM   account
                                           WHERE  linvoiceorganisation IN
                                                  (SELECT
                                                  linvoiceorganisation
                                                                           FROM
                                                  invoiceorganisation
                                                                           WHERE
       SP.linvoiceorganisation =
       invoiceorganisation.linvoiceorganisation
       AND ( Charindex(
       ','
       + Ltrim(Rtrim(Cast(invoiceorganisation.linvoiceorganisation AS
       VARCHAR
       )))
       + ',', ',' + Ltrim(Rtrim(@sSPID)) + ',') > 0 ))))
       --and e.dTransferStartDate between @dtStartDate and @dtEndDate 
       AND Cast(e.dtransferstartdate AS DATE) >= Cast(@dtStartDate AS DATE)
       AND Cast(e.dtransferstartdate AS DATE) <= Cast(@dtEndDate AS DATE)
       AND e.ireadinwith = @sSelectedSource
       AND e.estate = 3
       AND e.etransferdirection = 1
       AND efiletype IN( 128, 129, 130, 131 )