Finding the total query execution time

DECLARE @StartTime DATETIME
DECLARE @EndTime DATETIME
DECLARE @TimeDifference DATETIME
SELECT @StartTime = GETDATE()
------------------------------------
Your Qurey Here
----------------------------------
SELECT @EndTime = GETDATE()
SET @TimeDifference = @EndTime - @StartTime
SELECT DATEDIFF(millisecond,@StartTime,@EndTime) AS TotalMilliSecondsTaken
SELECT DATEDIFF(second,@StartTime,@EndTime) AS TotalSecondsTaken
SELECT DATEDIFF(minute,@StartTime,@EndTime) AS TotalMinutesTaken
select @TimeDifference as Difference,@EndTime as EndTime, @StartTime as StartTime