This is the MYSQL query, now I need this below dynamic query to be execute in TERADATA SQL.

    set l_sql=concat('SELECT max(',l_rid_col,'), MAX(cid) INTO @c2, @c3 FROM ',p_database,'.',p_table);
 
    SET l_rid = @c2;
    SET l_cid = @c3;

And this update query:

Good Morning All,
I've just changed roles. I've got about 4 years experience with MS SQL Server (T-SQL) and my new role uses Teradata.