SELECT COUNT(*) AS total FROM (
                                SELECT DISTINCT SOURCE,
                                    shipment,
                                    receiving_no,
                                    po_no,
                                    created_date,
                                    recqty,
                                    grqty
                                FROM SsFailedGR WITH (NOLOCK)
                                WHERE 1 = 1
                                {0} {1}
                                ) AS tab