use master
set nocount on
set dateformat dmy;
DECLARE @sd date, @ed date, @parid int, @tempid int, @spanid int;
set @sd= N'01.01.2015'/*вносим данные*/
set @ed= N'03.01.2015'
set @parid=1
set @tempid =20
create table #test1 (dt date,spanid int,paramid int, timesec int)
declare cd cursor for
select spanid from spaneddata
open cd
fetch next from cd into @spanid
while @@fetch_status=0
begin
insert #test1
select * from spaneddata where spanid=@spanid and (dt>@sd AND dt<@ed)
fetch next from cd into @spanid
end
close cd
deallocate cd

insert #test1
select * from spaneddata where spanid=@spanid and (dt>@sd AND dt<@ed)

declare cd cursor for
select spanid from spaneddata
open cd
fetch next from cd into @spanid
while @@fetch_status=0

fetch next from cd into @spanid
end
close cd
deallocate cd