If it's for a single stored procedure, wouldn't you just use WITH OPTION RECOMPILE?

At first I thought using DelimitedSplit8K would work for this... but I guess I didn't read the fine print carefully enough.

That will happen at 1:30 in the morning sometimes!

Here's a good article to read that you can adapt to answer your question:

http://dba.stackexchange.com/questions/86415/retrieving-n-rows-per-group

At least then you can give it a try and report back if you have problems. Helping...

Is this close?

-- create a cursor to loop over this result set

/* create a cursor to loop through each table... */

DECLARE @CmdLine AS NVARCHAR(200);

DECLARE @CmdCursor AS CURSOR;

SET @CmdCursor = CURSOR...

After taking Jeff's advice...

maybe this works?

SELECT Country

, AccountNum

, PolicyNum As CurrentPolicy

, LAG(PolicyNum,1) OVER (PARTITION BY Country, AccountNum ORDER BY PolicyEffDt) AS PrevPolicy

FROM @PolicyRelationship

ORDER BY Country

,AccountNum;

Nothing to it

SELECT * FROM #TEMP

ORDER BY NEWID();

NEWID() generates a random number for each record, so sorting by it causes a "random" sort.

This would be a much clearer question if you included sample data (create table scripts, insert scripts) and expected results.

I could rewrite the code this way...

SELECT personID

FROM #gradPerson AS g

WHERE NOT EXISTS (SELECT TC.PersonID

FROM TranscriptCourse AS tc

WHERE tc.PersonID = g.PersonID

Are you saying you don't understand...

What? I don't understand your question.

You've been here way too long to post questions like you do. No data, no table structures, nothing. As such, all I can do...

CREATE TABLE scripts? INSERT scripts with dummy data? Lots easier to sort out with at least something to work with. Without that I can only hazard a guess.......

Kevin,

Does your computer automatically play Pink Floyd whenever you're forced to work on it...? The till working in the background might be good incentive...

You can insert a row below the matrix outside the group and put the total there, and it will only show on the last page.

Right-click on the matrix/tablix, and in...

You're describing a matrix. You can add a totals column if you wish as part of the matrix.

I agree, but then it's not my homework. If you want good help, provide create table scripts etc.

Sorry, the more I read this, the more odd it sounds. Are you stuck with this table design? It just sounds a little off. I'm not sure i...