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...

I can generate purely random records really easily. TOP (@N) ... ORDER BY CHECKSUM(NewID)

The really hard part (for me!) is fixing my code so that as the grade increases,...

Here's one idea... definitely don't take any data that could be construed as belonging to your employer, but if you develop a solution, there's no reason you can't keep a...

You might want to read Ralph Kimball's The Data Warehouse Toolkit. (Or at least have a look.) It's not as scary as it sounds, really. He explains...

Well, at least you have a reason for your brain not working!

Yes... you have it right. Think of a patient receiving cancer treatments. He will receive treatments and...

Dwain,

Good to have a definitive answer. Thanks! Looks like I need a good reasonably simple tutorial on CROSS APPLY. I guess I could start with Paul White's...

Given that I'm not good at SSIS, I did this in Access, because it's what I know, and it works. (So it is good for some things!)

In my source...

So you're doing a self-join? Like in an Employee/Manager scenario?

See this article: http://msdn.microsoft.com/en-us/library/ms190273.aspx

Section E.

there...