Knowledge Base : Glossary : Suggest a Question
Search The Knowledge Base
Browse The Knowledge Base
Knowledge Base : RPOS

Printing Time Through Error On " subquery returned more than 1 value "

Problem

Printing Time Through Error On " subquery returned more than 1 value "






Solution

Steps

Step 1.

log in to database

( Ex: use medishopdb
go )

Step 2.

use the Following Query

select mp_item_code from med_productset group by mp_item_code having count(*)>1
go

[Use see the result for duplicate Item code ]

(EX: item code in 1234)


Step 3.

select * from med_productset where mp_item_code='item
code
'
go

( Ex : select * from med_productset where mp_item_code='1234' )

[Use see the result for MP_code ]

( EX: mp_code is like 987 )


Step 4.

select * from med_prodset_item_mast where mpim_code=987

[Use see the result for mpim_code ]

( Ex : Like 456 )


Step 5.

delete from med_productset where mp_code= 456
go


Step 6.

delete from med_prodset_item_mast where mpim_code=987
go



Problem is resolved


--------------------------------------T h A n K s $4$ U s I n G---------------------------------------------------
Regards,
SULTHAN-A

|Support Team|


Related Articles
There are no related articles


Viewer Comments Add Comment
No viewers have posted comments

Powered By AutoKB