No,
no need of GO. GO is just a batch separator in SSMS (QA). It is not a T-SQL command.

>>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
>
>