It's not clar what you are trying to do. Why do you want to return

Jill, 123, 'test' , 1, 8

Jill, 321, 'these', 1, 8

? What is the logic...

The hardcoded student ID is irrelevant. It's only there for simplicity. Obviously the query is not very versatile if that value (both occurrences) isn't replaced with a variable. But it's...

If it doesn't matter which 10 you update,

update top 10 n

set c = 'x'

from tablen n

where id % 2 = 0

if it...

Yes, as I would expect. But the poster says the query I posted (which is like your first one) still doesn't work, i.e. still excludes the unmatched record. If teh...

I can only post the same code again:

Do you expect a lot of failed updates? Do you need to do them as a series of individual transactions? If not, why not just do teh updates as a...

I agree that that was the problem with the original code:

where sar.companyID= 1370 and sar.studentID = 169 and termID is null

But the versions posted fixed that...

can you paste the exact code you ran?

The code as it stands should limit results to a single day, using the @date variable. You can get rid of operator by removing it from the SELECT list and...

It is relevant - because depends what you are using to render reports from the data, what data you need to return. You might be able return smaller parent and child recordsets...

where sat.companyID=1370

I thought you also wanted a crosstab/pivot table...?

select sat.AttendanceTyID

, sat.Description

, sar.AttendanceRuID

, 169 StudentID

, sar.AttendanceDate

, isnull(sar.RollupCount,0) RollupCount

from SchoolAttendanceTy sat

left join SchoolAttendanceRU sar

on...

Just out of interest, here's another test which suggests the opposite:

IF

Object_ID('[test_dt]') IS NOT NULL