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...

tudorn (1/6/2013)

---

Hi Sean,

Sorry I did not replied to you earlier.

The two posts/links that you recommended were very good and helped me a lot to create the reports I needed.

Thank you...

Assuming you want to have forms like you are used to with Access you...