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 SkipVought 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: *

  1. Boucaner

    variable assignment and EXEC

    Thanks gmmastros. I added an output param to the lowest level SP, and it worked.
  2. Boucaner

    variable assignment and EXEC

    We have a SP that returns one column from one row. It is called from within another SP via EXEC. I am trying to assign the returned value to a variable, but the variable is always 0 (default for type). exec @myVar = usp_my_sp @p1, @p2 A different table needs to be updated with the returned...
  3. Boucaner

    Using a stored proc in a select statement

    i'll give it a try. thanks for the help!
  4. Boucaner

    Using a stored proc in a select statement

    Howdy all, in a new stored procedure, i want to so a 'select ID from table' to get all of the IDs in the table, and then run an existing SP for each ID. Seems simple enough, but then so am I. Thanks

Part and Inventory Search

Back
Top