При проверке кода хранимой процедуры выскакивает ошибка the current limit of "4" is insufficient, что за лимит ей нужно добавить не пойму

Расскажу оп подробней, есть работающий запрос, надо пененести его в Reporting service, SSRS стоит, проверил запрос простенький, работает, а вот который по сложнее, сразу ругнулся на объявление переменных, в инете нашел, что надо часть кода засунуть в хранимую процедуру.Вот терь мучаюсь

use ProjectServer_published

set nocount on

declare @Bufer table (nomer int identity, Assn_Trans_UID uniqueidentifier, Spisano_Date int, h float)
declare @SPK_Assn_Change_Data table (Assn_Trans_UID uniqueidentifier, Spisano_Date int, h float)

declare @Assn_Trans_UID uniqueidentifier, @Assn_Change_Data varbinary(max), @i int, @j int, @Predel int,
@Delta int, @Task_Start_Date int, @Task_Finish_Date int, @h float


declare MainCursor cursor for
select distinct * from (
select datediff(dd, '19831231', isnull(isnull(t.Task_Start_Date,ts.Task_Start_Date ), lines.WPRD_Start_Date)) d1,
datediff(dd, '19831231', isnull(isnull(t.Task_Finish_Date,ts.Task_Finish_Date ), lines.WPRD_Finish_Date)) d2,
Assn_Trans_UID, cast(Assn_Change_Data as varbinary(max)) [Assn_Change_Data]
from MSP_Assignment_Transactions at
left join
(
select max(Mod_Date) [Mod_Date], Assn_Trans_Submitter_Res_UID, Proj_UID, Task_Published_UID from MSP_Assignment_Transactions
where Assn_Trans_State_Enum <> 0 -- Assn_Trans_State_Enum = 0 означает, что данные сохранены, но не отправлены
and Assn_Change_Data is not null

group by Assn_Trans_Submitter_Res_UID, Proj_UID, Task_Published_UID
) as tmp

on (at.Mod_Date = tmp.Mod_Date) and (at.Assn_Trans_Submitter_Res_UID = tmp.Assn_Trans_Submitter_Res_UID)
and (at.Proj_UID = tmp.Proj_UID) and (at.Task_Published_UID = tmp.Task_Published_UID)
left join MSP_Tasks_Saved t on at.Task_Published_UID = t.Task_UID
left join MSP_Tasks ts on at.Task_Published_UID = ts.Task_Published_UID
left join
(
select tsl.TS_Line_Cached_Assign_Name, tsl.Task_UID, tp.WPRD_Start_Date, tp.WPRD_Finish_Date
from MSP_TimeSheet_Lines tsl
inner join (select Task_UID, max(Mod_Date) Mod_Date from MSP_TimeSheet_Lines group by Task_UID) as ttt
on (tsl.Task_UID = ttt.Task_UID) and (tsl.Mod_Date = ttt.Mod_Date)
inner join MSP_TimeSheets tsheet on tsl.TS_UID = tsheet.TS_UID
inner join MSP_Web_Time_Periods tp on tsheet.WPRD_UID = tp.WPRD_UID
) as lines
on at.Task_Published_UID = lines.Task_UID
where isnull(isnull(t.Task_Start_Date, ts.Task_Start_Date), lines.WPRD_Start_Date) is not null
and isnull(isnull(t.Task_Finish_Date, ts.Task_Finish_Date), lines.WPRD_Finish_Date) is not null
) as t

open MainCursor

fetch MainCursor into @Task_Start_Date, @Task_Finish_Date, @Assn_Trans_UID, @Assn_Change_Data

while @@fetch_status = 0
begin
set @i = 44
set @Predel = datalength(@Assn_Change_Data)


while @i < @Predel
begin
set @Delta = cast(substring(@Assn_Change_Data, @i+1, 1) + substring(@Assn_Change_Data, @i ,1) as int)

if @Delta between @Task_Start_Date and @Task_Finish_Date
begin
set @j = @i+10
set @i = @j

set @h = dbo.fnBinaryFloat2Float(substring(@Assn_Change_Data, @j+7,1) + substring(@Assn_Change_Data, @j+6, 1)
+ substring(@Assn_Change_Data, @j+5,1) + substring(@Assn_Change_Data, @j+4,1)
+ substring(@Assn_Change_Data, @j+3,1) + substring(@Assn_Change_Data, @j+2,1)
+ substring(@Assn_Change_Data, @j+1,1) + substring(@Assn_Change_Data, @j,1)) / 60000

if @h > 0.0001
insert @Bufer select @Assn_Trans_UID, @Delta, @h

end

set @i = @i+1
end

insert @SPK_Assn_Change_Data
select @Assn_Trans_UID, Spisano_Date, h from @bufer
where nomer in (select max(nomer) from @bufer group by Spisano_Date)

delete @bufer


fetch MainCursor into @Task_Start_Date, @Task_Finish_Date, @Assn_Trans_UID, @Assn_Change_Data
end

close MainCursor
deallocate MainCursor
set nocount off



select distinct
rss.res_name,p.proj_name,ass.task_name, at.CREATED_DATE,at.ASSN_TRANS_UPDATE_DATE,ast.ASSN_TRANS_COMMENT, r.res_name
from @SPK_Assn_Change_Data a

inner join MSP_Assignment_Transactions at on a.Assn_Trans_UID = at.Assn_Trans_UID
inner join MSP_Resources as r on at.ASSN_TRANS_submitter_RES_UID = r.Res_UID
inner join MSP_Projects p on p.Proj_UID = at.Proj_UID
inner join MSP_ASSIGNMENTS ass on ass.assn_uid=at.assn_uid
inner join MSP_RESOURCES AS rs ON ass.RES_UID_OWNER = rs.RES_UID
inner join MSP_RESOURCES AS rss ON ass.WRES_UID_MANAGER = rss.RES_UID
inner join MSP_ASSIGNMENT_TRANSACTIONS_COMMENTS ast on at.Assn_Trans_UID=ast.ASSN_TRANS_UID
-

все разобрался

SQLPowerUser,

Да код Ваш, спасибо за предложение, сформулирую вопросы и напишу Вам :)