Jpotucek (1/27/2010)

---

SELECT a.Contact_info

,b.MEMBER_NUMBER

,c.CLIENT_NUMBER

,a.CONTACT_TYPE_ID

,a.history_YN

FROM FRATERNAL.CONTACTS a

inner join FRATERNAL.CLIENT_CONTACTS a1 on a.CONTACT_ID = a1.CONTACT_ID

inner join FRATERNAL.MEMBER b on a1.CLIENT_ID = b.CLIENT_ID

inner join FRATERNAL.CLIENT c on a1.CLIENT_ID = c.CLIENT_ID

WHERE a.CONTACT_TYPE_ID in ('Email1')

AND...

Try...

What is the nature of the job? Is it for a report, a one-off migration or part of a business process which could be run at any time?

How many rows...

klineandking (1/27/2010)

---

VALUES ('Emanuella','Edet',97,'2009-12-22')

VALUES ('Emanuella','Edet',76,'2009-12-20')

the question is ;

the question is i want to find the average grades based on the name and i want the result to include all other columns,...

You're welcome Jordon, and thanks for your cooperative effort.

Cheers

ChrisM

Yep that makes sense, thanks.

Combine your two subqueries into one, one scan of the tables will almost certainly cost less than two:

SELECT c.crs_id AS id,

...

A squash from your nice terracotta tiled roof 😉

Top work, Jorge. It's good to work with a poster who's prepared to put in some effort, as you have always.

benreeve007 (1/26/2010)

---

In this proc it was RoomCode which contained incorrect data in Visual Studio. Running the proc in Management Studio gave the correct data.

The same parameters were used in...

You mean, include into the report where

Any of the check values is equal to 1

AND

Any of the check values is equal to 0

Is this correct?

Isn't this the same as saying...

You have a closing quotation mark in the wrong place

,

print (@PivotTableSQL)

EXECUTE(@PivotTableSQL)' -- <-- closing quotation mark in the wrong place

which means that the PRINT statement and the EXECUTE statement are...

Which columns from this query appear to differ between the two client environments?

Why do you still include the local temporary table #sipDimensionPos in your solution? If you were creating it as a filtered subset of the table from which it is derived...

Hi Ben

Does the stored proc have parameters?

Can you post the stored proc?

Hi Jorge, you're just about there. The sample data obviously doesn't need to be in there, and the preselect which picks up id_CliPadre needs to be changed so that it...

It's beginner's TSQL, second day of TSQL 101 and you would benefit from spending a little time on it, which you clearly have...