Deleting 4000 different records from a table with where and conditions on each row.

Question

Post reply

Deleting 4000 different records from a table with where and conditions on each row.

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

deena 79174 (6/15/2011)
Thanks Ninja and everyone

My pleasure :hehe:.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Ninja's_RGR'us (6/15/2011)
SQLRNNR (6/15/2011)
You're welcome.
And the posts counter bumps continue!
No wonder you're catching up :hehe:.

He did say "Thanks...everyone"

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

SQLRNNR (6/15/2011)
Ninja's_RGR'us (6/15/2011)
SQLRNNR (6/15/2011)
You're welcome.
And the posts counter bumps continue!
No wonder you're catching up :hehe:.
He did say "Thanks...everyone"

Ya but you're not "everyone". :hehe:

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Ninja's_RGR'us (6/15/2011)
SQLRNNR (6/15/2011)
Ninja's_RGR'us (6/15/2011)
SQLRNNR (6/15/2011)
You're welcome.
And the posts counter bumps continue!
No wonder you're catching up :hehe:.
He did say "Thanks...everyone"
Ya but you're not "everyone". :hehe:

D'oh 😀

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Lowell SSC Guru Points: 323518 More actions · Answer 5

what's this post counter of which you speak?:-D

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 6

Lowell (6/15/2011)
what's this post counter of which you speak?:-D

Not sure... never heard of it b4 in my life, I swear.