Error appearing during datacopy to another table
I got error when the data copy from onetable to another database table
error message is"Msg 512, Level 16, State 1, Procedure trg_add_product, Line 23
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
"
then How to copy?
my code is
INSERT
INTO DbName.dbo.Table(product_id,product_code,product_name,category_id,tax_id,touch,qty,grwt,stwt,active,trans_date,purity_id,wastage_percentage,wastage_per_gram,va_percentage,va_per_gram)--
SELECT
* FROM NeDbName.dbo.Table1