Further analysis:

Variable @last_endtime is declared as char(14), then has various things done to it, and is then converted to numeric and has 1 added to it to add a second...

Sorry for the long delay in replying here. I lost track of this one somewhere along the way.

The proc references tables and other procs that you haven't provided definitions...

You need to change it to a Left Outer Join from an Inner Join, and you need to move the TransactionType into the join criteria instead of the Where clause.

Inner...

I assign it based on fragmentation speed. For static lookup tables, I build them at 100 and then put them in read-only files. Everything else, I have a...

Actually, if the whole grid fills up without a win, it will loop forever. Didn't spot that.

Needs to have the While clause modified to add:

and (select count(*) from #TicTacToe)...

This is what I can come up with for Tic-Tac-Toe in SQL:

if object_id(N'tempdb..#TicTacToe') is not null

drop table #TicTacToe ;

if object_id(N'tempdb..#Range') is not null

...

Given competent players, tic-tac-toe should always end in a draw. The game only works until you actually understand the mechanics.

jacroberts (8/13/2009)

---

GilaMonster (8/13/2009)

---

Plus who decides what's right? The last editor? What happens if someone comes along a couple months after an article's been published and edits garbage in. It may...

Jeff Moden (8/11/2009)

---

timothyawiseman (8/11/2009)

---

Steve Jones - Editor (8/11/2009)

---

What I would be happy to do is publish a list of "reviewers" on the writer's page and allow authors the ability to...

I certainly haven't. However, when I link...

Huh?

pls give me some tips...

You write them.

Awesome, Lynn!

To print an Execution Plan as a PDF, you first need a PDF-printer. http://www.cutepdf.com has a free one that works pretty well.

Then, display the plan in Management Studio. ...

Brad M. McGehee (8/10/2009)

---

Brad: I have to ask, is there a way for you to fix the title of this thread? The article title is correct, the thread title...