Delete Query

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » Delete Query

Delete Query

Rate Topic

Display Mode

Topic Options

Author

Message

JakDBA

Posted Wednesday, September 15, 2010 2:31 PM

SSC Rookie

Group: General Forum Members
Last Login: Friday, May 10, 2013 8:31 AM
Points: 38, Visits: 164

Hi friends need Delete Query

Delete from StoreGroupMember Where d in (select * from StoreGroupMember a ,store where a.Store_id=Store.id and store.StoreNumber=9833) d
Go

I need to Delete the Records which Satisfies the Below condition,

select * from Table1 a ,Table2 where a.Store_id=Tables2.id and Table2.StoreNumber='AAAA'

And i need to delete the records from Table 1 only,

EG;

Delete from Table1 Where d in (select * from Table1 a ,Table2 where a.Store_id=Tables2.id and Table2.StoreNumber='AAAA') d
Go

Please help me out...

URGENT

Post #986689

Evil Kraig F

Posted Wednesday, September 15, 2010 2:36 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 12:05 AM
Points: 5,688, Visits: 6,142

The more urgently you need something, the more time you'll need to take writing out the sample code you'd like us to mess with. A couple of things though:

That select * statement? It won't help us figure out what the key/keys are in Table1 to uniquely identify each delete.

General syntax though to delete:

DELETE t1
FROM
 Table1 AS t1
 JOIN
   Table2 AS t2
 ON t1.id = t2.id
WHERE
 t2.colB = @parameter

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables
Twitter: @AnyWayDBA

Post #986694

Derrick Smith

Posted Wednesday, September 15, 2010 2:38 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:04 PM
Points: 574, Visits: 684

This should work, I think..:

DELETE D FROM Table1 AS D
INNER JOIN StoreGroupMember A
ON A.Store_ID = D.Store_ID
WHERE A.StoreNumber = 9833

I think I got the tables right, but it's a bit unclear. Are the StoreNumber and Store_ID fields both in the StoreGroupMember table? And you want to delete by StoreNumber?

Post #986697

« Prev Topic | Next Topic »

Permissions