CREATE PROC [dbo].[Proc_GetRandomTime](@startTime datetime,@endTime datetime,@date datetime output )
AS
Begin Declare @MS int
Set @MS=DATEDIFF(ms,@startTime,@endTime) set @date=DateAdd(ms,Floor(@MS*rand()*5/8),@startTime)
End
CREATE PROC [dbo].[Proc_GetRandomTime](@startTime datetime,@endTime datetime,@date datetime output )
AS
Begin Declare @MS int
Set @MS=DATEDIFF(ms,@startTime,@endTime) set @date=DateAdd(ms,Floor(@MS*rand()*5/8),@startTime)
End