A. I have stated before that I CAN'T post exact code because I would not be employed for very long if I did.

B. I did come up with a way...

Two things kinda negate that. The tables are inviolate. They are what they are and can't be changed, been there since the 5th day of creation. The people who have...

In reality

Student FALL2012 WINT2012 ...

Col1, Col2,.... Are the terms.

Classes for the student for each term go under the term they are scheduled to be taken in and of course you can take more than...

whoops in response to the messy inconclusive.... yes it is. The first column is an id and no it doesn't matter, the ordering going down as long as the ids...

thanks for all the responses. yes it's random when the data gets changed (at the whim of an academic advisor) so unfortunately I had to do it in excel, works...

Get the first column value for the row. If the first column has the same value in the next row,move to the next row, do parse else do nextid

parse

Start...

OK, I've gotten rid of the duplicates using a case but now I have data that looks like this:

ID COL1 ...

I am trying to a non aggregate rollup... sort of.

I have columns for student, term1, term2, term3, etc.

The data under term is actually a course that is being taken that...

I certainly do appreciate everybody's responses. And there were no issues with the DB changing modes that showed up yet. Considering this is a well used database I guess that's...

Lowell,

You are the man! The databases that I can't create the functions on are 70. Where I can create them is 80. So, next question is what happens if I...

hey lowell,

was running around with fire hoses all day so I didn't get a chance to get back on. Hopefully today although my emails are piling up already. I will...

smunson,

I submit to an old coder's tenet "Why write it if somebody else already did, just borrow it" I found this code out on a MS (I believe) forum. It...

Thanks Lowell, I'll have to look at that!

jb

ps big Calvin fan here!

Yes, I've tried 3 different accounts with sysadmin roles. They all do the same thing. I've tried using both windows authentication and an entered login (SA) logging into SQL server....