Implementation of dynamic column names

To do dynamic column names, the method I've found now is to execute the query through a string and assign the column name to the dynamic value

DECLARE @sql NVARCHAR (MAX) = null--Defines the query statement executed
DECLARE @ParmDefinition NVARCHAR (4000) = NULL

DECLARE @Monday VARCHAR (10) = ' Dynamic column name '

SET @sql = '

SELECT
[Monday] As [' + @Monday + ']

From table name

‘

Variables that need to be used in a query statement

SET @ParmDefinition = N '
@p_LastWeekMonday DATETIME
, @p_LastWeekSunday DATETIME
‘
Executing a string query
EXECUTE sp_executesql @sql
, @ParmDefinition
, @p_LastWeekMonday = @LastWeekMonday
, @[email protected]

Implementation of dynamic column names