I've got a bunch of financial reports, and we want to be able to pass them two inputs (year and quarter) as variables.
I'm doing it this way, but I really don't like it:
declare @quarter int,
@year int,
@date date
set @quarter = 4
set @year = 2018
set @date = cast(@year as varchar(4)) + '-01-01'
set @date = dateadd(quarter, @quarter - 1, @date)
print @date
Question What is the best way to reconstruct a date from integer inputs?
desired result:
2018-10-01
Best Answer
You could Create a date dimension or calendar table in SQL Server and query it