DECLARE @dtReportingPeriod DATETIME SELECT @dtReportingPeriod =CAST(CAST(DATEPART(MM, ReportingPeriod)-1 AS VARCHAR(4)) + '/' + CAST(DATEPART(DD, ReportingPeriod) AS VARCHAR(4)) + '/' + CAST(DATEPART(YYYY, ReportingPeriod) AS VARCHAR(4)) AS DATETIME) FROM Sector WHERE SectorID = @intFromSectorID AND InActive = 0
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)