The result set with parameters set to return data with

number of days between rfdates set to less than or equal to 10

and DISCCD in ('EEX','CO2')

would look like this

CUSLINK, TOTAL

2232,...

You are correct.. my bust.. missed the second one. I will edit the initial post to reflect. Thanks.

That is exactly what I need...

THANKS!!!

Sorry .. guess I missed that in your suggested article..

I've edited the initial post to reflect this requirement.

I need a count of cuslinks with differend dispcodes and different dates as one record count based on the recordsets having the same cuslink, specified dispcodes, and the referdate being...

Thanks.. took your suggestion and edited the initial post to contain the recommended code.

Thanks for the fishing lesson and rod!

If my data changes calendar year (which it does, as I'm measuring data throughout a school year... September one year to June of the next year) will need to...

The data spans two calendar years (one school year)...

September one year to June the next year

If the field name in this case is "referdate", where does it go with your code?

referdate (MM,GETDATE()) ?

my example of course which did not work.. thus...

I appreciate your effort.   Thanks!

Because I'm a newbie .. and thought that would be easier than trying to nuke out a set based method...

The basic problem here is this.   We have a table (SASI.ACHS5031) containing course history records from previous grades and schools attended for currently enrolled students.   The records are of...

I'm puzzled because I don't know as much about TSQL as you do.. quite obviously.

Yes... I had not declared all of the variables.  Once I did that, I am left with all the "if" errors...

  I'm puzzled.

Server: Msg 156, Level 15, State 1,...