DECLARE @VAR_SQL NVARCHAR(1028); SET @VAR_SQL = N'DROP VIEW IF EXISTS VW_SUMMARY_INFO'; EXEC sp_executesql @VAR_SQL; SET @VAR_SQL = N'CREATE VIEW VW_SUMMARY_INFO AS SELECT COUNT(*) AS MY_VALUE, ''PRIME NUMBERS FOUND'' AS MY_DESCRIPTION FROM [MATH].[dbo].[TBL_PRIMES] UNION ALL SELECT MY_VALUE, ''TOTAL NUMBERS SEARCHED'' AS MY_DESCRIPTION FROM [MATH].[dbo].[TBL_CONTROL_CARD]; '; EXEC sp_executesql @VAR_SQL;