GilaMonster (10/5/2010)

---

Not any more... All the MCDBA exams (excluding maybe 1)...

GilaMonster (10/5/2010)

---

I'll disagree slightly...

Books alone will not make you a master. Books + experience + experimentation may, with sufficient...

Or script out the schema, recreate, and then to a data flow task for every table (you may need to drop all foreign keys, insert data, then recreate them).

See here: http://www.sqlservercentral.com/Forums/Topic672795-145-1.aspx

edit: disregard, same link that Shawn posted. Yay Google!

Any time 😀

Ah I was posting that as you replied with the extra criteria..

try this

;WITH CTE AS ( SELECT

RN = ROW_NUMBER() OVER (PARTITION BY...

Something like this would just return the serial numbers ordered 2 or more times in the last 60 days from today's date. Without table schemas/data I can't completely verify it..but...

tosscrosby (10/5/2010)

---

Lowell (10/5/2010)

---

Derrick Smith (10/5/2010)

---

Wait, we need "reasons"...

Getting closer..just need some specifics.

How do you want it to be displayed? Do you just want a list of serial numbers that have been ordered twice in the last 60...

Yep.

Table structures, some sample data, expected output, and what you have written so far will be enough to answer 99% of the questions you will ever post.

We'd need a bit more info from you to help out with an accurate query

Refer to this post by the resident metal bar hater: http://www.sqlservercentral.com/articles/Best+Practices/61537/

You can output failed rows to a file using -e c:\errorfile (or whatever path you'd like).

That's 2 terabytes, which when talking about memory in MS products, is synonymous with 0 or Unlimited.

You'll see those 3 interchanged quite frequently, but they all mean the same thing...

I prefer staging tables for the simple reason that if something fails, you can just select from it and see which data might be causing the issue instead of filtering...

Robert Hankin (9/28/2010)

---

Again a good suggestion and again (unfortunately) a limit of my ERP Software. The table constraints are all based on unique indexes (on all 6000 tables) without...