Just so you know, Colorado is great.

This was my conference call on Wed morning, in a long sleeve shirt.

This was today:

Brandie Tarvin (2/3/2012)

---

Do the Google thing to all your computers then tell the family that the blizzard is so bad, it's snowing in...

snow, snow, snow.

snow. coming down, not too hard, but steady.

Grr, I hate CS databases.

Note added to the question

If this is some type of homework or test, you need to make an attempt at the query. We are happy to help, but not do the work for you.

Delete...

First, please don't cross post to other forums. People scan all places.

Second, please give DDL and tables so someone can test and provide help. Include data as well:

create table tbl_indicator

(...

It's completely contained in msdb, so it can be backed up.

It's also an SSIS package, so you can open it in BIDSs and move it that way as well to...

Maybe, but there is a large, very active SQL Server community on twitter and we use it daily to bond, teach, learn, and build relationships.

There's...

Two...

Gary Varga (2/2/2012)

---

Rod at work (2/2/2012)

---

Semicolons will at some point be required in T-SQL? Really? I've seen it used in some cases, but am completely uncertain as to...

Gary Varga (2/2/2012)

---

It was when I looked at the side-by-side stored procedures example that it became clear. Literally!!!

I shall be using the = syntax moving forward. My reasoning? The intention...

paul s-306273 (2/2/2012)

---

I've used the SELECT 1 x; format for years. (Oracle background).

I've never found it confusing - I don't now discard that format just because somebody else finds it...

We'll see. I...

Points were awarded back.

I cut / paste the wrong way. I can't change the answer once people have answered, so I was looking to move answers around.