Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.
ALTER PROCEDURE [dbo].[sp_GetIndividualHolidayReport] ( @Username varchar(50) ) AS DECLARE @StartingHolidays decimal(4,2) DECLARE @StartingDate date SELECT @StartingHolidays = (Select Top 1 Days FROM dbo.StartingHolidays WHERE Username = @Username) SELECT @StartingDate = (SELECT [StartDate] FROM [Timesheets].[dbo].[Periods] WHERe IsCurrent = 1) SELECT TIMESHEET.DATE, 1 AS Days, @StartingHolidays AS StartingHolidays, ApprovedHolidays.TimeSheetID, ApprovedHolidays.DateAproved, ApprovedHolidays.ApprovedBy, ApprovedHolidays.Notes, ApprovedHolidays.UserName FROM TIMESHEET Full Outer JOIN ApprovedHolidays ON TIMESHEET.RefId = ApprovedHolidays.TimeSheetID WHERE (TIMESHEET.IdVolNow = @Username) AND (TIMESHEET.ContractId = 136) AND @StartingDate >= @StartingDate
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.