If you want to get only those records with a certain HalfID value, you need to restrict your result set to those with the desired HalfID. Read up on...

Nice script.

A couple of questions for you:

- Shouldn't there be a set of [ ] around the variables in case they contain special characters like...

Craig. Here is an alternate approach using a temporary table to assemble the result set. I was having trouble reconciling the denormalized results (grade for each...

First, review this item about the best way to post data and pose questions on the forums.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Then... you need to limit the subqueries to the class you are looking...

As was said .... you need to end the outer case statement

select p.first_name

,p.last_name

,p.people_code_id

,case when td.event_id='sd 100' then (case transcript_seq when '002' then

(select final_grade from people as p

inner join...

I'm still not quite with you on that but... try this. If there are multiple values for event_id for a person (which I suspect), then you...

Craig. The MAX portion adds nothing I can see since max(case when td.event_id ='SD 100' then td.final_grade else null end) as 'SD 100' still gives the...

First you should read the information available on Transactional replication from SQL Server Books Online, if you have specific questions, please ask them then.

Toni

Look up the Processmon utility from Microsoft (it's free) and it will help determine file usage.

http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx

Toni

There are 2 problems I see. First if @Rank is null then concatenating it to a string would yield a null string. Second if @Rank is...

Hi. There is a windows utility called Filemon which will show dynamic file usage.

You can get it at

http://technet.microsoft.com/en-us/sysinternals/bb896642.aspx. In order to halt the...

Oh.. . and I am not sure what you are trying to accomplish with the

select ...,max(case when td.event_id ='SD 425' then ) as 'SD 425'

elements. ...

Sorry - I keep losing connections here... in any case, if you post the schema

table names, columns/datatypes, keys (PK FK) , and some sample data, I...

OOOPS... lost connection

*** IGNORE THIS POST - GOT SENT WHILE MY CONNECTION WAS ACTING VERY STRANGELY ***

I need to find a students final grade from the transcriptdetail table, and i...