Based on the data provided in your original post, what would be the expected result?

tstaker (2/24/2010)

---

Lynn Pettis (2/24/2010)

---

I have to disagree here. This is a good way to see how some thinks. Do they write a cursor or while loop to complete...

reidres (2/24/2010)

---

Lynn Pettis (2/24/2010)

---

My problem with comparing the two solutions above is you are actually comparing apples to oranges. Jason's routine is returning the results...

tstaker (2/24/2010)

---

CirquedeSQLeil (2/23/2010)

---

reidres (2/23/2010)

---

OK, I ran Jason's (CirquedeSQLeil) updated code (modified by me as before) and got 0:54, which puts it as the fastest time of the scalable three that...

jcrawf02 (2/24/2010)

---

Interesting change Lynn. I love when you guys start testing competing methods, because it always means that I'm going to learn good stuff without actually having to *do* anything...

Improved the performance of my code, I moved the row_number() function into its own CTE instead of in the last CTE accomplishing CROSS JOIN's. Increased performance almost 50%.

My problem with comparing the two solutions above is you are actually comparing apples to oranges. Jason's routine is returning the results directly where as...

And?

Please be aware that by using the ALLOW_DATA_LOSS repair option you may have done just that, lost data. Please start a scheduled backup plan immediately so that if this...

GT-897544 (2/23/2010)

---

SAT_SQL (2/23/2010)

---

Hi

All

my DB, please provide any step by step procudure for the .

It look like this satmman(suspect)

primary database coruppeted,it is in the suspected mode want to...

I posted my solution to the FizzBuzz challange on AskSSC. :smooooth:

Should we save the 12,000 post for Gail when she gets back from being on-site with a client?

On a count down to 12,000 posts on The Thread!

It would help if you could post the full error message(s) you have found in the SQL Server log files.

What version of windows is being used? IIRC Windows 2003 and newer are actually case sensitive with regards to user names. (But then I may be wrong.)