I have a date range object with the date density binding to a stored procedure -
execute spWorkOrdersDateRangeDensity '{Root Container.Filter.Date Range.startDate}', '{Root Container.Filter.Date Range.endDate}'
Copying a string version of the query that appears in my error message works in my MSSQL studio however. The actual stored prrocedure is such -
ALTER PROCEDURE [dbo].[spWorkOrdersDateRangeDensity] (
@startS varchar(50),
@endS varchar(50)
)
AS
BEGIN
declare @startDT smalldatetime
declare @endDT smalldatetime
Set @startDT = cast(@startS as smalldatetime)
Set @endDT = cast(@endS as smalldatetime)
declare @returnTable table([t_stamp] date, [weight] int)
declare @idx bigint
declare @createDate smalldatetime
declare @t_stamp smalldatetime
declare @completedDate smalldatetime
select @idx = min([idx]) from workorders where [createDate] < [completedDate] and [createDate] >= @startDT and [createDate] <= @endDT
while @idx is not null
begin
select @createDate = [createDate], @completedDate = [completedDate] from workorders where idx = @idx
select @t_stamp = @createDate
while @t_stamp <= @completedDate
begin
insert into @returnTable([t_stamp], [weight]) Select @t_stamp, 1
Set @t_stamp = dateadd(mi, 10, @t_stamp)
end
select @idx = min(idx) from workorders where idx > @idx
end
insert into @returnTable([t_stamp], [weight]) Select @endDT, 0
return select top 1000 [t_stamp], [weight] from @returnTable order by [t_stamp]
END
GO
Why is this giving met his error?