jamie_collins (1/31/2012)

---

I am going to play around with it... I may need to add the AUDITDATETIME field in at some point and then reverse the query so I can...

sartis (1/31/2012)

---

I'm trying to generate a query that will return all 6 projects and then select the projects that a person is flagged with in the contactrecord_project table

I apologize I...

If you take a look at the first link in my signature, it'll show you how we prefer your sample stuff to be setup so we can use it instead...

There isn't an alternate. Because dependency association is less than perfect, sp_refreshview is the only way to change the metadata if the underlying schema changes. You could just...

steve 22165 (1/31/2012)

---

Hi, Thanks for looking....I'm new here and did not know about the Forum Etiquette...sorry

In the where clause the 5142 is an id of the person.....so that is why...

Jeff Moden (1/31/2012)

---

It's a...

steve 22165 (1/31/2012)

---

Ok...I have 2 tables....Projects and contactrecord_project

Projects table has these columns and there is example data below

---------------------------------------------------------------------------

Project_name_id Project name

1...

DavidL (1/31/2012)

---

Craig (and others reading):

Here is the stored procedure text. It is very slightly different what I first posted, but not in essence. There are no SET... statements...

It's only paranoia if...

Jack Corbett (1/31/2012)

---

I mentioned the computed column because I wasn't sure if it needed to be writable.

I'll have to play around a bit with the sample...

zwheeler (1/31/2012)

---

Hi

Question:

FETCH NEXT FROM Cur1 INTO @pid_A, @date_start_A, @date_end_A

FETCH NEXT FROM Cur1 INTO @pid_B, @date_start_B, @date_end_B

When the sql is executed for Cur1

does this contain the same rows or does...

Thanks for the additional information above David. So, some clarifications if you'll be so kind, and hopefully some ideas on what we can look for in regards to troubleshooting.

DavidL...

Personally I usually end up having to write up trees, or get a little zany with bullets, or sketch a quick mental diagram, or...

... I get tired trying to pull...

Dbloc (1/31/2012)

---

I must mention that there are some other columns in the table that are specific to each row. I should have mentioned this right away but forgot. sorry 🙁

So...

Without schema, I can't hand you actual code, but what's the concern doing something like the following:

SELECT

BldgID,

UserID,

Max(SomeDate) AS MaxDate,

Min(SomeDAte) AS MinDate

FROM

-- Joins go here

GROUP BY

BldgID,

UserID