I think I can... I think I can... 🙂

guerillaunit (2/21/2012)

---

Is there anyway to GROUP BY a CASE statement (or achieve the same results with a different method) in the same query? ie.

SELECT

CASE

...

GilaMonster (2/21/2012)

---

SQLKnowItAll (2/21/2012)

---

GilaMonster (2/21/2012)

---

No offence intended, but from what you've said that sounds like a completely wrong approach.

A seek is not better than a scan. Forcing a seek with something...

GiantBenMav (2/21/2012)

---

All that is secondary. Really it comes down to:

1. I have a maintenance plan job

2. I want to start that job in another job

3. I do not want...

DBAgal (2/21/2012)

---

SQLKnowItAll (2/21/2012)

---

I guess I have not run into a case where an application "needs" 2005 versus 2008. If it can run on 2005, it does not take much...

I guess I have not run into a case where an application "needs" 2005 versus 2008. If it can run on 2005, it does not take much to have...

You're still not answering my questions. ...

Most likely a permissions issue for your user on that instance. Express and CE (compact edition) don't have it.

🙁 Sorry!

GiantBenMav (2/21/2012)

---

I want to index the tables I am loading data into before they are used later in the job. When i run the maintenance plan as a step...

GilaMonster (2/21/2012)

---

No offence intended, but from what you've said that sounds like a completely wrong approach.

A seek is not better than a scan. Forcing a seek with something like WHERE...

GiantBenMav (2/21/2012)

---

I have created a Maintenance plan to index some tables, takes about 15 minutes to run. After reloading tables in a large job i want to run the...

My suggestions are to use the tutorials, not to just start reading.

EDIT: Missed page 2

I would go to the BOL tutorials. Even if some of it is review, I always relearn something. Then after that you can go to the Itzik Ben Gan...