Creating views sounds like a better approach. If you have data that is related to the customer but is not as important then splitting to an extension type table is...

Just shoot me!!! That is a nightmare!!!

There are a couple options as I see it. Either normalize that table into something that makes sense or suffer horrible performance.

Since you are using a correlated subquery why bother with any of those approaches?

This returns the same thing.

select *

from seats s

join seats2 s2 on s.ID = s2.id2

And FWIW, you...

BOL has the answer to this and MANY MANY more questions.

http://msdn.microsoft.com/en-us/library/ms178107.aspx

Sounds like you need to get a better understanding of how to generate catch all queries which is what it sounds like you are running here. Take a look at...

PiMané (1/8/2013)

---

Hi,

Is it best to have a table with 400 columns or if the application has several screens to update/insert the information should the table "reflect" those screens?

For example a...

gchappell (1/8/2013)

---

my company wishes to add 200 million new products in the next 10 days. Does sql server 2012 have any limits as to how much data can be added...

Good question Tom. Good to have a refresher on these things from time to time.

jasona.work (1/7/2013)

---

Stefan Krzywicki (1/7/2013)

---

Brandie Tarvin (1/7/2013)

---

jasona.work (1/7/2013)

---

It's not that bad...

I've...

Thanks for posting ddl and desired output. The following mostly works for you example but it includes Rating3 which in your sample output it was missing.

select stuname,

case when s.facultyid...

I don't understand. You...

Your sample data is obviously not complete. It is totally useless in it's current form. You have two tables, one with a date and one with a varchar. There is...

It looks like that is a great candidate for converting to a table parameter. It would certainly make this a lot easier to maintain.

CREATE TYPE VarChar8K as Table

(

Col1 varchar(8000) null

)

Then...

manik123 (1/7/2013)

---

Actually i am new for table design. i added one new column like [insred_name] in existing table with spelling mistake. then i changed that column...

Jeff Moden (1/6/2013)

---

I have to say that's one of the longer belated thank-you's I've seen in a while and I still think it's very cool that you came back to...