If i only could put here the code, ehhh
alter procedure [dbo].[test]@multiple_weeks varchar(4000)
as
declare
@val date
create table #ps(id varchar(30),week varchar(8)[...])
declare c1 cursor for
select CONVERT(varchar,Item,112) FROM [dbo].[DelimitedSplit8K](@multiple_weeks ,',') Myfn
open c1
fetch next from c1 into @val
While @@fetch_status <> -1
begin
insert into #ps id,CONVERT(varchar,@val,112), [...] -- complicated select with a lot of calculations
fetch next from c1 into @val
end
close c1
deallocate c1
select [week, id, etc] -- select from temp table with calculations
from (select week, id, etc from #ps ) d
where date in @multiple_weeks -- they have here where however data previously are selected only for 2 dates
The schema is like this. When i execute it for one date, its ok, for second, its ok. But when i execute it for 2 dates, i see in PRINT commands parameters in cursor are ok (Date is changing) but i have no data.
I have deleted last where and i got data but data for first date duplicated with second date as below
20150101 10 12
20150106 10 12
20150101 15 20
20150106 15 20
Maybe im ending the cursor in wrong place? But i dont think so. If i end it after select, i would get 2 separate sets of data