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

select *

from tablename

where deptnumber = &department_number;

Enter Value for department_number

if you do this in SQL Server...

SELECT *

FROM tableName

WHERE deptNumber = @DeptNumber

You will get a prompt in the GUI. If...

I'm queuing specific data from column called Node Alias, for example:

NodeAlias = '101.101.101.101' or NodeAlias = '102.102.102.102' etc.

So, my reporting works, but I want to rename what is viewed in...

Could you give an example of what you mean by "rename output data"? Do you mean aliasing column names so they display as something other than their original names...

Your table is really structured like that? What happens if you get more software packages? Does the table structure change? IF y

I think storing information using this structure/pattern...

You can import your reports into SSRS from Access, and as long as you're not using VBA functions in queries that your reports are based on, they should work. ...

How about:

SELECT x.Days, AVG(x.No_Of_IDs) As AvgCount

FROM

(SELECT Days,

count([ID]) as No_OF_IDS

FROM [Proddata]

LEFT OUTER JOIN SupplyData as S ON Proddata.Group = S.Group

GroupBy Days

) x

GROUP BY x.Days;

No CTE required.