Abdu Rafeeq

Abdu Rafeeq

  • NA
  • 113
  • 265.3k

Error appearing during datacopy to another table

Mar 15 2011 5:59 AM
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

Answers (2)