CREATE procedure St_Proc_GetUserReportforCurrentDayTask @userID int as Begin set NoCount on; DECLARE @TODAY DATE SET @TODAY = CONVERT(VARCHAR(10), GETDATE(), 111) select CONVERT(VARCHAR,production.CalendarDate,101) + RIGHT (CONVERT(VARCHAR,production.CalendarDate , 100 ) ,7) as Date, RegionAndProjectInfo.RegionProjectName as Region , County.CountyName as County, WorkType.WorkTypeName as WorkType, Task.TaskName as Task, Production.VolumeProcessed as 'Volumes Processed', Production.TimeSpent as 'Duration' from Production inner join RegionAndProjectInfo on RegionAndProjectInfo.RegionProjectID=Production.RegionProjectID inner join County on County.CountyID=Production.CountyID inner join WorkType on WorkType.WorkTypeID=Production.WorkTypeID inner join Task on Task.TaskID=Production.TaskID where Production.UserID=@userID and CalendarDate >= @TODAY End
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)