I agree too. The query posted matches exactly to the desired results you posted. Excellent job posting ddl, sample data and desired output!!! I wish more people would do that.

You...

ACinKC (6/5/2012)

---

How 'bout Sammy (Samuel) Smith's Oatmeal Stout? Around here (Kansas City), Freestate Brewing (Lawrence, KS) has an Oatmeal Stout that is really good, too (and a nice restaurant...

nu_bie (6/5/2012)

---

Sean Lange (5/31/2012)

---

OK I will try one last time. You keep saying you want to auto-populate this table. I understand the table and relationship but I don't understand the...

I googled that error message and there are tons and tons of people with different solutions to this issue. It seems there is an answer out there that will help...

No an identity is not a primary key. They are however often used as a primary key. I...

WOW your datatypes are a disaster. I don't mean to sound insulting but these tables have so many problems it is hard to comment on all of them.

--------------------------

Table AAA

--------------------------

password column...

Not a free solution but the one from redgate sounds pretty solid.

http://www.red-gate.com/products/sql-development/sql-source-control/%5B/url%5D

Also I googled "sql server tortoisesvn" and got thousands and thousands of hits. I am sure if you dig...

Rem70Rem (6/4/2012)

---

Hi,

Thanks for your reply.

Basically what I want it a copy of the DDL in case someone mess with some objects. We don't have a source control and I...

This one comes up around here all the time. Here is a nasty script I wrote several years ago to do this.

DO NOT RUN THIS IN PRODUCTION!!!!

declare @table_name varchar(2000)

declare @sSQL...

This sounds like a cross tab.

http://www.sqlservercentral.com/articles/T-SQL/63681/%5B/url%5D

http://www.sqlservercentral.com/articles/Crosstab/65048/%5B/url%5D

Ken at work (6/4/2012)

---

Can you use a variable with a view?

I have a view that joins 5 tables, one of which is an OpenQuery. Is there anyway to choose...

How about fn_split?

There is not anyway to automate that type of script generation. This stuff is not easy to put together. How do you handle things like foreign keys? They would have...

IgorMi (6/4/2012)

---

Hi

You have more ways. It's one right now on my mind. You could put your code, which selects the 20 rows, in a CTE and with an index for...

GilaMonster (6/4/2012)

---

Open is the alias for the subquery. It's valid, though probably should be in [] as a...