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.