What have you tried so far? Also, for better help with your problems, please take the time to read and follow the instructions you will find in the first...

I had technical difficulties last night and couldn't get anything...

I would add that it also depends on how the data is being queried and how the NC indexes are defined.

Not knowing anything more than what you posted, it really...

Jeff Moden (6/5/2011)

---

Lynn Pettis (6/4/2011)

---

Okay denizens of The Thread, I got a call yesterday evening from my oldest daughter that actually left me speechless.

I am going to be grandfather![/i]

Looks like...

Okay denizens of The Thread, I got a call yesterday evening from my oldest daughter that actually left me speechless.

I am going to be grandfather![/i]

Looks like I'll need to get...

Had a phone interview Thursday morning with Microsoft. It seemed to go pretty good. We'll know how good if the fly me up to Redmond for a full...

I'm finally starting to look more at Visual Studio 2010 and I'm curious if any of the denizens of The Thread have played around with F#.

Seems interesting even though you...

Start by reading about dynamic sql. See how it is written and how it can be used. Once you understand the concepts you can then ask better questions...

You need to use dynamic sql. Start by looking that up in Books Online.

jcrawf02 (5/27/2011)

---

Kiara (5/27/2011)

---

GSquared (5/27/2011)

---

A friend of mine says that what a friend of his does is buy old clunker cars, usually for around $2,000 or so. Then the only...

Stefan Krzywicki (5/27/2011)

---

GSquared (5/27/2011)

---

Stefan Krzywicki (5/27/2011)

---

GSquared (5/27/2011)

---

ALZDBA (5/27/2011)

---

GilaMonster (5/27/2011)

---

Elliott Whitlow (5/26/2011)

---

Jan Van der Eecken (5/26/2011)

---

GilaMonster (5/26/2011)

---

One very uncomfortable PM sent...

From the posts the person has made, they are totally out...

I'm lucky, I don't have a wife/kids, and although I don't want them, that's not the point. It's every man's absolute RIGHT to be able to provide for a family,...

Brandie Tarvin (5/26/2011)

---

Grant Fritchey (5/26/2011)

---

Brandie Tarvin (5/26/2011)

---

Gotta love a query that, when executed, complains about a non-existent table but then, when you look at your code, you're not even calling...

Actually, if you look into the different retirement accounts you can setup as a self-employed individual (in the United States) you can actually set...

I did the following using Oracle (yes, that's what I am working with right now) but you should be able to adapt the query for use in SQL Server:

with salesprods...