Of course you are right:)
Cetin

>Isn't inserted and deleted tables only available in TRIGGER?
>I read this in BOL and never tst to see if they are available in SP :-(
>
>>Tim,
>>PMFJI. If you need to return the updated records, why don't you simply select them from inserted table? Something like this:
>>

>>CREATE PROCEDURE dbo.GetSpotsByCompanyIDWithRange
>>(
>>	@CompanyID UniqueIdentifier,
>>	@StartRange DateTime,
>>	@EndRange DateTime,
>>	@Sentinel Bit,
>>	@SentinelMark VarChar
>>) 
>>AS
>>BEGIN
>>	SET NOCOUNT ON;
>>	-- Set the Sentinel Mark, Status, And Status Time
>>UPDATE TrackSpot
>>	SET SentinelMark = @SentinelMark,
>>		Record_Status_dt = @SetTime,
>>		Record_Status = "Sentinel Marked"
>>	WHERE s.CompanyID = @CompanyID
>>		AND Spot_Time >= @StartRange
>>		AND Spot_Time <= @EndRange
>>		AND Sentinel = @Sentinel
>>
>>  
>>  SELECT * from inserted -- return the inserted rows
>>  -- I didn't list fields for simplicity
>>END
>>

Cetin