hello Wayne,

Looks like I am missing records because I am interested in getting first follow up date but I am not getting next follow up date right after the appointment.

for...

how can I query this for all the students.

I have testdate and the yearago date from the testdate with studentid and subject usinfg this query :

select Studentid, Lname,Fname,testdate, subject ,...

Thank you all.

I was joining on applicantid earler and using the condition where Program_Code=Math using where clause, hence the output was not same what I wanted.

Blyzzard

Thank you for the response.

The only problem is there can or cannot be a record for an applicant in the review table and I want to get all the...

Also there are 2 similar kind of report with these fields prelim and final. Can I use parameters for the users to select prelim and final report and then display...

Yes, I can create the temp table to get all the data into temp table but for the user to be able to click on each total # column to...

Thanks ZZartin and JeeTee. It worked.

My Table Structure is :

Table1 :

Studentid,

Program,

Plan,

ACT score,

SAT score,

Rank,

SpecialProgram

Table2:

Studentid,

Program,

Plan,

SpecialProgram,

HN,

SH

where HN and SH are bit field to mark 1 or 0 based on the scores and the...

The query works fine when the emplid does not exist in Table2, so it inserts the new record.

Since I want to keep all the historic record in table2 and if...

There are 2 parts of this problem:

I am trying to insert the records in table 2 if the combination of (emplidApplicationID+programID ) from table1 does not exist in table2

or...

Thank you SSC-Enthusiastic. This works when the emplid does not exist in table 2 but how can I add the query when emplid is not null and I need to...

The error is :

Invalid column name Decision1

Thanks for correcting the syntax but I am still getting error for Decision1 in where clause.

Do I need to use the subquery for Decision1 in where clause?

Thanks,

Blyzzard

In the both source tables, class section is varchar but I was using cast because of the alphanumeric characters for the previous year.

but I think you are right as I...

Thanks for your response.

It could be possible as the updates were being run a day before.

Is it possible to go back to the original execution plan?

Thanks,

Blyzzard

Sean, do you mean same code but instead of calling sp just fore trigger when the value changes?

Please bear with me as I am a newbie.

Thanks