Thanks guys for the replies.

I'm going to check out the link Craig! Thx

Table Value Parameters seem like a lot of work. I don't fully understand how a user is supposed...

Thanks very much for all the replies. I greatly appreciate them.

Thanks! I'm going to save that article for reference. It is good to know that a lot of signs and symbols will evaluate to NUMERIC = TRUE including d and...

i can increase the sample size if need be.

Sorry I was having some trouble the resultset was too large and even the resultset specified above was over 1 million records and would not fit in an attachment.

I created...

Well it helps to fix problems when you take out unnecessary COMMIT TRANSACTION!!!!!

Thanks guys! At least you started me to thinking.

Thank you SO VERY MUCH! You are exactly right about the error message I'm getting. I fixed that one by replacing the = sign with the IN operator. But I'm...

Thanks. Now i don't remember having this problem in the past with SS 2005. Any comment? Did it change? I could test it but i believe i've played with 2005...

I think i figured out the problem. I had to click on EDIT alongside the table giving me problems and change the datatype. It was usually the date datatype that...

Thanks that is what i want to know.

Chris, i need to run home for a minute. I will look at your solution ASAP!

Thanks for the effort!

Ok the conclusion I've come to is that I restricted too early on. If i had just allowed the cartesian product on the query and then looked at it and...

Thanks a million Ken! That's exactly what i want! I understand how you got them in the same record using AND R2.RowNum = R1.RowNum + 1 .

OK, i...

Hi Ken. Thanks very much. I'm still studying your query just to learn how i could do this differently (syntax wise). However, your query STARTS with INITAL enrollment then withdrawal....

For StudentID 577, if anyone is confused, There is an EnrollmentID of 559. It is an error. It got included by mistake and is not part of the data.