How to use DELETE command in SQL SERVER 2005

Hi,

I would like to do the following:
DELETE FROM PS_NCSR6200
WHERE STRM IN ('1092')

I get the following error:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

This was not an issue in the previous version of sql server.

I have tried to do what is in the help files but nothing is working.  

Any assistance would be greatly appreciated,

Lucy
BrockAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

chapmandewCommented:
Are you sure you posted your actual query?
0
BrandonGalderisiCommented:
Perhaps you are doing:

DELETE FROM PS_NCSR6200
WHERE STRM =('1092')

and '1092' is populated by building a dynamic Query string and in some cases it build a query like this.

DELETE FROM PS_NCSR6200 WHERE STRM =('1092', '1024')
^^ THIS will NOT work.  But I can assure you that what you posted is valid SQL.

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BrockAuthor Commented:
Ok,  I found out what the issue is.  The table had a trigger and that is why I was having problems perrfoming the command.

Thanks to both for your quick response.

Lucy
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.