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!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Cursor result set problem
Here is the whole stored procedure code. I am using the tblCurrentInventory to update and add component data and I am trying to get back the whole result set and not just 1 row. CREATE PROCEDURE sp_AddComponentDetail( @LocationID int, @ComponentID int) AS DECLARE @CompID int DECLARE...- mcshanemi
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Cursor result set problem
I am attempting to update an inventory table using a cursor but my result set is only bring back 1 row instead of all rows which was what I was expecting. Code: CREATE PROCEDURE sp_AddComponentDetail( @LocationID int, @ComponentID int) AS DECLARE @CompID int DECLARE @Date datetime...- mcshanemi
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
