HOLY COW ... this is exactly what I need ... dongadoy .. thank you so much (_)>

Thanks dongadoy ..... this is exactly what Im looking for! I do have one question though. based on your table ... right now ....if an...

Right now we are using SQL Server 2000 🙁

Thanks Lynn for the post. I can certainly appreciate the need for the information spoke of in the links you posted. Im not a very good SQL'er ...

Hey thanks for the reply .... Actually I guess I should have explained that I need everything that is returned all on the same line. This is to...

Wow ... that would suck !! I thank you for the correction. I obviously try to solve the issue using web resources and trial and...

Jeff Moden (11/18/2008)

---

The question Christopher is asking is what is in the mdtrans table that is also in the TESTsalescontract table? For example, is there a ResortID column in...

Ahhhh ...... Well testsalescontract.id = mdtrans.contractid

Im kinda a newbe at this .... please explain ... thanks

Lynn Pettis (5/20/2008)

---

Your welcome. Just to follow-up though, do you know why I made the suggested change in...

Awesome ... done deal ... Thanks sooooo much !!!!!;)

After playing around a little ... I was able to get this to work ....

select

UniqueID,

sum(case termcd when 'BM' then 1 else...

I guess Im a total newbe cause I have no idea how to integrate Johns with yours.

whether its positive or negative ........