Creating reports and dashboards | Stimulsoft community forum

Code: Select all

alter procedure iwMESMachineCenterWorkGet
@cWcId varchar(20),
@dtFrom datetime,
@dtTo datetime,
@bDebug int = null
as
begin
	SET @bDebug = CASE WHEN @bDebug > 0 THEN 1 ELSE 0 ENd
	set @dtFrom = isnull(@dtFrom, getdate()-1 )
	set @dtTo = case when isnull(@dtTo, @dtFrom) > @dtFrom then @dtTo else @dtFrom + 1 end
	
		
	create table #mcWork( iId int identity primary key, cUserId varchar(20), cUserDesc varchar(100), iYear int, iPeriod int, dtLogDate datetime
		, cScheduleId varchar(20), cScheduleDesc varchar(100)
		, cProjectId varchar(20), cProjectDesc varchar(100)
		, cElementId varchar(20), cElementDesc varchar(100)
		, cTaskId varchar(20), cTaskDesc varchar(100)
		, cLaborType varchar(20), cLaborTypeDesc varchar(100)
		, cUM varchar(20), dWorkTime decimal(15,5)
		)

	insert into #mcWork
		select '52981', 'TOM SOYER', 2016, 5, '2016-02-02T14:07:36.000', '100', 'Test shift'
		, 'S74300183', 'DK6- parts', '10002', '982_02_08 hold', '45', 'CNC drilling', '151', '1.st shift', 'h', 1.00000

		
	select * from #mcWork
end