DECLARE @timeval AS DateTime
SET @timeval ='05:23:34'
DECLARE @Timetbl as table (tmval datetime)
While @timeval <>'00:00:00'
Begin
INSERT INTO @Timetbl
SELECT @timeval
SET @timeval=DateAdd(ss,-1,@timeval)
End
INSERT INTO @Timetbl
SELECT @timeval
select * from @Timetbl