Amazing question. Even more amazing is that I got it right. I guessed, admittedly. But I will run and study the code, because it's a really cool puzzle.

By the way,...

Cool question, thanks.

- webrunner

"What do you want to learn?"

1. More about automating DBA tasks.

2. More about set-based SQL.

3. More about security.

By the way, Steve, congratulations on your whirlwind tour. That sounds like a...

Tej_7342 (11/7/2013)

---

New data will inserted every day so, we would want to keep only 2 weeks worth of data. Hence we would want to implement something recursive which will delete...

Great question. I didn't know about the WITH VALUES option before this.

Thanks,

webrunner

For once I didn't fall for the trick!

Wow, that is odd. My ratio is 1:10, just like Steve said in the editorial.

- webrunner

Yelena Varshal (9/27/2013)

---

Hi,

yes, you can run SSRS on Standard edition.

Please review comparing features by edition

http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx/css

Features Supported by the Editions of SQL Server 2008 R2

and scroll down to the Reporting section....

Thanks for your reply!

I have one additional question - is it necessary to run Enterprise Edition for a report server of smaller scale, or would SQL Server 2008 R2 Standard...

Seed Vicious (9/16/2013)

---

webrunner (9/16/2013)

---

Thanks - could you post any more information on this, such as a specific error or one of the Microsoft fixes or support documents about this issue?...

Thanks -...

Steve Jones - SSC Editor (9/11/2013)

---

Hugo Kornelis (9/11/2013)

---

And to all people who think they need to post to "get their point back" - rubbish! Points are never subtracted for giving...

Ross.M (9/11/2013)

---

webrunner (9/11/2013)

---

The correct answer given the original question is 0 rows. Noticing that by reviewing the code in your head is not cheating. Copying and pasting the code and...

batgirl (9/11/2013)

---

Ross.M (9/11/2013)

---

Though...

Great question idea, problem in the execution.

I got it right by choosing 2, but sadly if there is a string truncation error and the results returned are 0 with the...