One Star

sql query to select count and insert in table.

Hello, I am having trouble in writing an SOL query which counts the number of rows in a table and inserts that count value in another table.
Anyone here familiar as to how to approach this??
Note: I want to insert the query in tSQLquery.
1 REPLY
Community Manager

Re: sql query to select count and insert in table.

Hi
"Select count(columnName) from tableName" on txxxInput component. If I don't understand your request well, please give us more details.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business