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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.