Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by macatter

  1. macatter

    how to not return data from a stored procedure

    Thanks for the info. You've confirmed what I thought. There's really no easy way. Thanks again.
  2. macatter

    how to not return data from a stored procedure

    Ya, I thought of that two, but I also don't want to run the select twice, you know? I'm hoping that there's some other way, but my hope is not so high...
  3. macatter

    how to not return data from a stored procedure

    I'm using SQL Server 2000 and I have a stored procedure where it's possibly to return up to 20,000 rows from the select statement inside. I would like to use the TOP function to just return the top 500 rows, and if there are over 500 rows (which I'll find out from @@rowcount) then I would like...
See more

Part and Inventory Search

Back
Top