SELECT * Returns 1 Record, But SELECT COUNT(*) Shows 3k+ Records
So I figured this out less than a minute after I hit post, despite thinking about it and googling for a bit.

So the problem is that I ran a procedure earlier that deleting some duplicate values in a table using SET ROWCOUNT 1 and a WHILE loop.  I realize that I didn't actually set rowcount back to zero (SET ROWCOUNT 0) after the break in the loop.  After doing that, I can see all the records now.