Everyone has their own way of laying out code. This is how I like to do it using the example several have used in this thread:

SELECT

...

Guess I'll have to check this out from home. Can't view the site here at work.

😎

Time to ask a question, why the sub-total every 5 records? Seems to me this should probably be done on the application side, not the database side of things...

The only gotcha I would warn about is regarding SSIS packages. When you create an SSIS package with a script task, be sure to select the option to precompile...

There is another way to do this, without using convert. The second select statement is equivalent to the first:

select datediff(week, convert(varchar(6), getdate(), 112) + '01', getdate()) + 1

select datediff(week,...

Not that I am aware of, sorry. You can setup a DDL trigger to capture that event at a server level, or setup a trace to capture that as...

I think the difference between a 5 of 10 and a 9 of 10 (to use a scale) isn't so much the amount of knowledge but more the intuitive thought...

It isn't that we are trying to down play our knowledge, it just the more we learn, we learn that there is more we don't know.

Maybe I am better than...

Life lesson -- There is always something new to learn, even when you think you know it all!

You can bury me when I stop learning.

Actually, I haven't even thrown in SSIS, SSRS, or SSAS. If I added those in, my score would drop. On SSIS (2 or 3 of 10), SSRS (1...

GSquared (3/3/2008)

---

Lynn Pettis (3/2/2008)

---

....

I appreciate the compliment. Now you've set the bar for me even higher. I would be lucky to put myself at 5 out 10...

You are even more limited if you are using the embedded version of SQL Server that is loaded in a single server install. We have two installations of Windows...

Okay, I feel even smaller now with all this praise. Jeff, the last word most people at work would use to describe me is humble. At work, yes,...

GilaMonster (3/2/2008)

---

Lynn Pettis (2/29/2008)

---

Since you would ask about Statistics in an interview, what can do you look for in an answer? I have been working with MS SQL Server...

You won't. You are rounding to the 100ths...