>No,
>The only difference is what data you will get from SELECT.
>With the code I posted you will get old data, with moving UPDATE before SELECT you will get updated data.
>

Right, but that is exactly what I need. The sentinel Mark I am updating is supposed to mark the records that have been retrieved. Now I am wondering how I seperate these two operations. Doesn't the "Update" need a "GO" in there before the "SELECT" Occurs; but it is inside the BEGIN and END?

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  s.Track_Id,
		s.CompanyID,
		s.TruckID,
		t.TruckCode,
		s.DriverID,
		s.Truck_Ip,
		s.IsTip,
		s.Spot_Message,
		s.Route_Day,
		s.Route_Number,
		s.Municipality,
		s.Upload_Id,
		s.Spot_Latitude,
		s.Spot_Longitude,
		s.Spot_Heading,
		s.Spot_Speed,
		s.Spot_Altitude,
		s.Spot_Time,
		s.Spot_Status,
		s.Sentinel,
		s.Record_Status,
		s.Record_Status_dt
	FROM TrackSpot s, TruckAccess t

	WHERE s.TruckID = t.TruckID
		AND s.SentinelMark = @SentinelMark

END
GO