I am pretty new at sql.
I want the following:
SELECT transID from tblTrans WHERE transDesc = @TransDesc
UPDATE tblData SET Complete = GETDATE() WHERE transNo = (Result from First Query)
How do I put the result of the first query into the 2nd query.
UPDATE tblData SET Complete = GETDATE() WHERE transNo IN (SELECT transID from tblTrans WHERE transDesc = @TransDesc)
There are two ways of doing this. The first follows your original, and assumes there is only one transID:
DECLARE @transID int
SELECT @transID = transID from tblTrans WHERE transDesc = @TransDesc
UPDATE tblData SET Complete = GETDATE() WHERE transNo = @transID
The second is neater, as it puts the entire update into a single command:
UPDATE tblData SET Complete = GETDATE()
FROM tblTrans t
WHERE t.transID = tblData.transNo
AND t.transDesc = @TransDesc
UPDATE tblData
SET Complete = GETDATE()
WHERE transNo IN
(SELECT transID
from tblTrans
WHERE transDesc = @TransDesc)
Try this...
UPDATE tblData SET Complete = GETDATE()
WHERE transNo IN (SELECT transID from tblTrans WHERE transDesc = @TransDesc);
