TheSQLGuru (11/4/2010)

---

I am going to step outside the box here and ask WHY you want to put a nonclustered index on a temp table?? In almost 15 years of...

Thanks to all of you for your help! 🙂

GilaMonster (11/2/2010)

---

Correct. Index names only have to be unique within a table, while constraint names have to be unique in the DB

CREATE TABLE #t1 (id int)

CREATE TABLE #t2 (id int)

CREATE...

GilaMonster (11/2/2010)

---

Yes it will, because you've explicitly named the constraints (not indexes) and those names must be unique in a database. Indexes just have to be unique on a table

This...

Craig Farrell (11/2/2010)

---

Goldie Lesser (11/2/2010)

---

All 3 of these fail:

CREATE TABLE...

All 3 of these fail:

CREATE TABLE #Table1

(

TeacherID ...

Thanks for the excellent article! It was very clear and informative!

I think a deeper understanding of how the optimizer works helps us to write better queries.

Looking forward to the rest...

Wow. Thanks for all the extra info, Mike.

Much appreciated!

Mike C (7/1/2010)

---

Good catch on the week # UMG. As you mentioned, I did assume 2005 or 2008, but only because 2000 is out of support :). If using...

simflex-897410 (5/17/2010)

---

no, I am doing this with Sql Server Reporting Services; nothing to do with .net.

So, I build the sql using query analyzer. When I get the results I am...

simflex-897410 (5/17/2010)

---

Thanks a lot again, Goldie.

I am still struggling with the dynamic date. I will continue to try to figure it out.

It isn't making sense to me. I am more...

Think about it this way. You know the list of dates before you start the query.

Then you can use them as columns.

You can try something like this. (no promises that...

You're quite welcome!

I know that Goldie's is only missing the YTD total that's as a result of waiting...

I could make the pivot dynamic, but first I want to make sure the data is what...

The reason no one has responded is that...