• Thanks everyone,

    Turns out this was causing the return of -1:
    SET NOCOUNT ON
    If I set NOCOUNT to OFF, it returns the number of rows.