SELECT

p.ProjectName as PName,

man.UserName AS Manager,

dev.UserName AS Developer

FROM @project p

CROSS APPLY (

SELECT STUFF( (

SELECT ', ' + man.UserName

FROM @Manager m

INNER JOIN @User man

ON m.Managerid = man.Userid

WHERE...

GilaMonster (8/23/2013)

---

Ah, "English Barbecue" granite.

GilaMonster (8/23/2013)

---

Fal (8/22/2013)

---

Speaking of fruit. The missus and I are getting a new kitchen in and are trying to finalise a few issues.

We were thinking of getting a stone...

dwain.c (8/22/2013)

---

Fal (8/22/2013)

---

Speaking of fruit. The missus and I are getting a new kitchen in and are trying to finalise a few issues.

We were thinking of getting a stone...

Bill Talada (8/22/2013)

---

I still strongly disagree. UDFs are much, much easier to incrementally add customization rather than throw away a CTE because it can no longer be used because...

Bill, it's not a personal thing, we all make mistakes. The point of folks posting faster and more efficient code samples is that any posted code here in ssc could...

Calamari

Post the definition of the object tmp_Brad_Product_Configuration_12months. Without knowing what it is, it's difficult to answer your question with any degree of confidence.

Cadavre (8/21/2013)

---

I enjoyed it, found some of the questions in the audience...

Cadavre (8/21/2013)

---

kapil_kk (8/21/2013)

---

Cadavre (8/21/2013)

---

kapil_kk (8/21/2013)

---

Koen Verbeeck (8/21/2013)

---

Sure. This is one of the examples where you don't need a tally table.

You can replace the logic beneath @bit = 1 with one...

npranj (8/21/2013)

---

Yes thanks for highlighting that. I did check the indexes on the table. There is a covering index in place already. I was getting an index scan on that...

npranj (8/21/2013)

---

Hi Chris.. am afraid will not be able to put the execution plan of the query here due to confidentiality issues.

However, the exec plan had all Index Seeks and...

npranj (8/20/2013)

---

I am facing issues with a LEFT JOIN in my query. It takes 45 secs to process on the production server due to huge number of records. Need help...

It has to be indexed to work...

A primary key doesn’t have to be indexed, although SQL Server will create a unique clustered index on a PK by default; likewise, the clustered index doesn’t have to be...