1
Answer

Generate Dynamic Date Columns as per input.

Dwarkesh Vajjala

Dwarkesh Vajjala
Jun 18
340
1 
DECLARE @StartDate DATE = '2024-01-01';
DECLARE @EndDate DATE = '2024-01-07';


-- like a temprary table must be create with columns as.

-- thes start date and end date is dynamic. so it can go 7 columns , 12 columns , 70 columns..etc

_____________________________________________________________________________________________
id |2023/01/01 | 2023/01/02 | 2023/01/03 | 2023/01/04 | 2023/01/05 | 2023/01/06 | 2023/01/07 |
---------------------------------------------------------------------------------------------



so i want dynamic generated columns  for the temporary table. where the StartDate and EndDate are dynamic example 7,14,90 days.

 

Answers (1)
Next Recommended Forum