declare @NumberOfBeats int;
set @NumberOfBeats = (111 * 4);
declare @LengthOfSong time;
set @LengthOfSong = '00:03:21:921';
declare @LengthInSeconds int;
set @LengthInSeconds = (
select convert(
int,
datediff(
cast(
(second,
current_timestamp,
(current_timestamp + @LengthOfSong))
) as time
)
)
);
-- select @LengthInSeconds;
-- Result is 202 seconds
select cast(
((@NumberOfBeats / @LengthInSeconds) * 60)
as decimal(6,3)
);