Bill Talada (6/12/2014)

---

Game over. Human player wins in 39 shots!

I'll quit now while I have zero losses.

Thanks for the fun game. Nice interface.

I'd really like to see this rewritten...

Great article. Thanks for sharing!

below86 (6/4/2014)

---

Sean Smith-776614 (6/2/2014)

---

below86 (6/2/2014)

---

I've played about 4 times so far, haven't lost yet. Come close to loosing, been down to my patrol boat but was able to sink...

below86 (6/2/2014)

---

I've played about 4 times so far, haven't lost yet. Come close to loosing, been down to my patrol boat but was able to sink the computers remaining...

jpk 91966 (6/2/2014)

---

Great Script and has a lot of features that new SQL developers can use as a learning tool.

First Game: Loss in 34 shots. But I was hunting down...

SCGJohn (5/27/2014)

---

Game over. Computer player wins in 44 shots!

Was head to head with the AI and would have won on the next shot. Nice job - very interesting use...

below86 (5/27/2014)

---

It was good, the computer had three ships grouped close together, which helped my score. The other two where near by. The only thought I had was...

Gotcha. Good score...

Ah, same here. 🙂 I have 2008 R2 locally so I just run it off my machine. 🙂

Which version of SQL Server are you running? 2005?

Thank you! And I agree, which was part of the inspiration for this bit of code. 🙂 Hope you enjoyed it.

Try running it with both the OR and the UNION and compare the query plans. Save the plans and post them here if possible.

Why thank you! Hope you enjoyed it. 🙂

They are really great. The Sam's one gave me my start many years ago, the other showed me a lot of great advanced stuff.

That and I moved this to the end:

Skip_Agent_Jobs:

IF OBJECT_ID (N'tempdb.dbo.#temp_sssr_agent_jobs', N'U') IS NOT NULL

BEGIN

DROP TABLE dbo.#temp_sssr_agent_jobs

END

GO

Here are two great books if you want:

http://www.amazon.com/Sams-Teach-Yourself-SQL-Minutes/dp/0672336073/ref=sr_1_1?s=books&ie=UTF8&qid=1399427202&sr=1-1&keywords=sam%27s+teach+yourself+sql

http://www.amazon.com/Microsoft-Server-Fundamentals-Developer-Reference/dp/0735658145/ref=sr_1_1?s=books&ie=UTF8&qid=1399427180&sr=1-1&keywords=t-sql+fundamentals

Sean