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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: oalex
  • Order by date
  1. oalex

    stored procedure & blank return value/output

    Thanks, SQLSister, for the quick response. here's the source: PROCEDURE1:: CREATE PROCEDURE p_procStat @intAccountID int, @intSessionID int, @intZIPCode int, @intMilesRange int, @chrVehType int, @intVehModlYR int, @chrVehMake char(15), @chrVehSeries...
  2. oalex

    stored procedure & blank return value/output

    I have a stored procedure to query a db by a given zipcode range. works just fine and returns selected records as well as a return value and some output values to be posted on web (asp). Now, within the stored procedure i want to check if @@rowcount < 10. if true, i need to increase zipcode...
  3. oalex

    Updating SQL databse

    Need help:What is the best way to update SQL (V7) database?<br> Receive about 500,000 records every week - need to check if ea record already exist. If it does, need to check which column(s) needs to be updated, otherwise add record to database<br> is there a simple solution?<br> <br> Does a...

Part and Inventory Search

Back
Top