OK. I still don't know what your question is. Given your description of what you want in the table what would the table look like?

So what is it that you need help with? Do you have an idea of what your Region table might look like?

deemurphy_us (1/27/2012)

---

In the database I want to create I want a table with regions in the US, states for the regions, their abreviations and their postal code (AR), the next...

This bol link will explain check constraints. http://msdn.microsoft.com/en-us/library/ms188258.aspx

I'm really glad they've added the FORMAT function in 2012. As much as there's an assumption that date format manipulation shouldn't happen in the database, it's nonetheless important for a...

If you are looking for teams that have no...

Loundy (1/26/2012)

---

You won't be able to combine the results from both statements as the columns are not the same. If the columns were the same in each statement you...

What you are describing is running totals. This article http://www.sqlservercentral.com/articles/T-SQL/68467/%5B/url%5D by Jeff Moden has a great of accomplishing this.

Not only is that one option it works in just about any...

raisleger (1/25/2012)

---

Pretty close, but the "Total" column is incorrectly valued with "6" versus the expected "12" (5 + 1 + 4 + 2).

Any additional ideas?

CardType ...

Hi and welcome to SSC. In order for somebody to offer much help we need some help from you first. If you can post ddl (create table statements), sample data...

I can't really figure out what benefit you gain by getting a non-null row count for each column. To do this you will have to use dynamic sql. You will...

Somebody else want to take a look at this? http://www.sqlservercentral.com/Forums/Topic1240364-392-1.aspx

He is trying to match some transactions and I stumped how to even begin. The logic behind what defines a match...

LOL. If it was difficult to stump me perhaps. 😀 I can the group and see if anybody else...

I can't come up with anything other than RBAR for this. I would think about doing this in an external app because I suspect you are going to have to...