SELECT Contact_ID, Student_ID, Contact_txMail

FROM dbo.Contact

where Student_ID in ( select Enroll_status, Student_ID

from dbo.Student_Info

where Enroll_status = 'true');

So you only want a single record from Contact for each StudentID?

SELECT Contact_ID, Student_ID,...

INTERSECT should be equivalent to INNER JOIN, as any non-matching values fall out of the result.

EXCEPT and INTERSECT were added in SQL2005.

The other way to do it is to use a Matrix in SSRS. You could base your report on a stored procedure that accepts the date range you want...

Grant Fritchey has posted at least a few database maintenance videos on YouTube. Definitely worth watching if you're not really comfortable with backup/restore. Absolutely something to practice at...

But what if it's a Babelfish and I need it to speak T-SQL?

Jeff,

I think that's how I got the random number of records per enrollment so that the distribution is irregular. I noticed that Chris's code returns the same number of...

Dwain,

Okay, must be that the candy canes and eggnog are working... This seems to work okay, and pretty quickly (haven't tested it, but it's less than a second to...

nevermind...

Are you looking for a crosstab? I'm just not very clear on your requirements.

I Grouped by X and then added a couple of columns and dropped the fields into the grid.

=Min(Fields!X.Value,"DataSet1")

=Max(Fields!X.Value,"DataSet1")

No idea where SUM fits into this... I didn't need it.

For grins I...

If you wanted to store NULL and a DATE value, then it would be trivial. What's the point storing ''? Is that not the same as Null (unknown)?...

CI = Clustered Index (one per table, determines storage order)

NCI = Non-Clustered Index

Your field sizes and some of the types are a bit over the top.

DOB NVARCHAR(50)? Makes doing date math really hard.

ID NVARCHAR(50)? Can't you use an...

Okay, thanks for the clarification. I'll post again if I can't figure something else out about the solution.

Dwain,

First off, thanks for taking the time to crank that out... Of course, it'll take me a while to figure it out!!!

The grades are from the National Institute of Health...