Loop in Stored Procedure 1

[Elton1984]

Hiz all,
Reallie in need of some help here..
My stored procedure onli update the last record of the DB.

DECLARE @prdtID varchar(10)
SELECT @prdtID = a.PrdtCode FROM tblPrdt a LEFT OUTER JOIN tblLoan b ON a.PrdtCode = b.PrdtCode WHERE (b.LoanIndex IS NULL)
UPDATE tblPrdt
SET PrdtStatus = 'On Loan'
WHERE PrdtCode = @prdtID

I know that i am needed to input a loop somewhere in my codes but i seriously have no idea of where and how to do it.. Ermz anyone haf any ideas?

Thanx in advance
Elton Wong

 

[JohnDTampaBay]

No need for a loop. Update all applicable product statuses at once. How does this work for you? Good luck!

UPDATE tblPrdt
SET PrdtStatus = 'On Loan'
FROM tblPrdt a
  LEFT OUTER JOIN tblLoan b
    ON a.PrdtCode = b.PrdtCode
WHERE (b.LoanIndex IS NULL)

--Angel
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)