LOL. You guys recruited...err stole...Jewsbury...

kpwimberger (3/8/2013)

---

Thanks Jeff and Sean. The fix Sean steered me to to (using XML PATH and STUFF in a corelated query) worked! Now I just need to pull it all...

It would be better if you had read the article. The problem is it is really hard to visualize your tables and...

From what you are describing it sounds like what you have is over complicated for the results. It is however pretty much impossible to offer any kind of direct help...

It seems that Gail beat me to it. 😀

This should work. Although it seems a little complicated for this.

drop table #score

go

CREATE TABLE dbo.#score

(

StudentID int IDENTITY (1,1) NOT NULL

, Math ...

I took the liberty of making your sample data and table work correctly.

if object_id('jwmTestCert') is not null

drop table jwmTestCert

CREATE TABLE [dbo].[jwmTestCert](

[abr_ID] [nvarchar](10) NOT NULL,

[cert_id] [int] NOT NULL,

[field_id] [nvarchar](3) NOT...

Lynn Pettis (3/7/2013)

---

Sean Lange (3/7/2013)

---

Kansas City area. I am actually in a town just to the West of the metropolitan area with a few miles...

For some reason the attachment is still not working. I am wondering if your stats are out of date but I can't get the attachment.

Here are a couple of observations....

Kansas City area. I am actually in a town just to the West of the metropolitan area with a few miles of farms in between.

Yes for tblFact. However, the view has a few other tables in it.

HOSP_UID_Xref

aprdrg_lkup

minormkt

And not your fault but the attachment for the...

Lynn Pettis (3/7/2013)

---

wolfkillj (3/7/2013)

---

Lynn Pettis (3/7/2013)

---

wolfkillj (3/7/2013)

---

Lynn Pettis (3/7/2013)

---

jcrawf02 (3/7/2013)

---

You're absolutely right, the players should pay attention to what the ref is calling, not what the rules say, because then...

kk1173 (3/7/2013)

---

Guys - If I run the query without any function it still takes a long time to execute. So use of function is not the issue here.

Any other...

Lynn Pettis (3/7/2013)

---

wolfkillj (3/7/2013)

---

Lynn Pettis (3/7/2013)

---

Sean Lange (3/7/2013)

---

Lynn Pettis (3/6/2013)

---

Several years ago my oldest daughter's JV soccer coach once confieded "I knew we were in trouble when half the team...

Wow it is still scary how...