try this:

DECLARE MY_CURSOR Cursor

FOR

SELECT [DB_NAME],[SCHEMA_NAME],[TABLE_NAME],[COLUMN_NAME] FROM dbo.Data_Profile_Stats

Open My_Cursor

DECLARE @DB_NAME nvarchar(500),@SCHEMA_NAME nvarchar(500),@TABLE_NAME nvarchar(500),@COLUMN_NAME nvarchar(500), @QUERY NVARCHAR(MAX)

DECLARE @MAX_NUMBER NVARCHAR(255),

@MIN_NUMBER INT,

@NULL_COUNT INT,

@BLANK_COUNT INT,

@ZERO_COUNT INT,

@DISTINCT_COUNT INT

Fetch NEXT FROM MY_CURSOR INTO @DB_NAME,@SCHEMA_NAME,@TABLE_NAME,@COLUMN_NAME

While (@@FETCH_STATUS = 0)

BEGIN

SELECT @DB_NAME,@SCHEMA_NAME,@TABLE_NAME,@COLUMN_NAME

SET @QUERY='SELECT @MAX_NUMBER MAX('+@DB_NAME+'.'+@SCHEMA_NAME+'.'+@TABLE_NAME+'.'+@COLUMN_NAME+') FROM '+@DB_NAME+'.'+@SCHEMA_NAME+'.'+@TABLE_NAME

EXEC SP_EXECUTESQL @QUERY, N'@MAX_NUMBER NVARCHAR(255) OUTPUT', @MAX_NUMBER = @MAX_NUMBER OUTPUT

SELECT @MAX_NUMBER

FETCH NEXT FROM MY_CURSOR INTO @DB_NAME,@SCHEMA_NAME,@TABLE_NAME,@COLUMN_NAME

END

CLOSE MY_CURSOR

DEALLOCATE MY_CURSOR

GO

Not sure what you are trying to accomplish here.