• Your requirements are very unclear. Do you need to get records in relation to single requested id? Then you could use the following:

    declare @table table (dt datetime, id int)

    insert @table select '2012-09-01 00:00:01.123', 11

    insert @table select '2012-09-01 00:01:00.456', 22

    insert @table select '2012-09-01 00:01:02.456', 33

    insert @table select '2012-08-31 23:59:58.456', 44

    declare @reqid int

    declare @reqdt datetime

    set @reqid = 11

    select @reqdt = dt from @table where id = @reqid

    select *

    from @table

    where id != @reqid

    and dt > dateadd(SECOND,-61,@reqdt) and dt < dateadd(SECOND,61,@reqdt)

    Please provide the case setup as per link at the bottom of my signature. It will give much better idea on what you really want to achieve.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]