Execute dynamic SQL with parameters

CREATE OR ALTER PROCEDURE [dbo].[Customers_Mechanism]
(
	@customerId INT,
	@dateCreated datetime
)

DECLARE @tblCust varchar(50),
	@tmpQuery VARCHAR(MAX);

--physical temporary table name
SET @tblCust = CONCAT('tmp_', @mercantId);

--restrict table names to 128 chars
	IF LEN(@tblCust) > 128
	BEGIN
		SET @tblCust = SUBSTRING(@tblCust, 1, 128)
	END

--create table or truncate if exists
	IF EXISTS (SELECT TOP(1) 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'dbo' AND TABLE_NAME = @tblCust)
		BEGIN
			SET @tmpQuery = 'TRUNCATE TABLE ' + @tblCust
		END
	ELSE
		BEGIN
			SET @tmpQuery = 'CREATE TABLE ' + @tblCust + ' (
				[CustomerId] INT NOT NULL,
				[Address] [nvarchar](200) NOT NULL,
				[Telephone] [nvarchar](11) NULL,
				[Amount] [decimal](18, 2) NULL
			)'
		END

--execute SQL string
EXEC(@tmpQuery);

IF @@ERROR <> 0	
	RETURN 0; 

--Dynamic with parameter
SET @tmpQuery = 'INSERT INTO ' + @tblSETS + ' (CustomerId, Address, Telephone, Amount)
				SELECT CustomerId, Address, Telephone, Amount from Customers where dateCreated = @d'

--execute SQL string with param
EXECUTE sp_executesql @tmpQuery, N'@d datetime', @d = @dateCreated

IF @@ERROR <> 0	
	RETURN 0; 

-- src - https://stackoverflow.com/a/32516310

EXECUTE sp_executesql @tmpQuery, N'@address nvarchar(200), @telephone nvarchar(11)', 
                              @address = @address, @telephone = @telephone;

-- src - https://www.red-gate.com/simple-talk/blogs/using-xml-to-pass-lists-as-parameters-in-sql-server/

DECLARE @sqlCommand nvarchar(1000)
DECLARE @XMLlist XML = '<list>*2**4**6**8**10**15**17**21*</list>'

SET @sqlCommand = 'SELECT x.y.value(''.'',''int'') AS IDs FROM @data.nodes(''/list/i'') AS x ( y )'

EXECUTE sp_executesql @sqlCommand, N'@data XML', @data = @XMLList