Thanks for the reply. I eventually found the "?" works with ODBC. I'll try the ":" with the Oracle drive. Are you aware of any good documentation...

Thanks GSquared. That worked.

It's not homework.

Does my lack of sql knowledge make me appear to be a student?

As someone who generally posts more questions than answers, I thought this was a great article. Any way to make this required reading before someone creates their first post?...

Thanks!

I'm using SSRS and a MSSQL 2005 back end. Never thought of trying to put it in the dataset. Seem there should be a way to do this...

Thanks!

DDL

Attached has show the problem with the columns.

This is going to be long ...

CREATE TABLE [dbo].[studemo](

[suniq] [int] NOT NULL,

[ident] [varchar](10) NOT NULL,

[stuuniq] [int] NULL,

[firstname] [varchar](16) NOT NULL,

[middlename] [varchar](16) NULL,

[lastname] [varchar](20)...

mengus,

Sent you a PM.

I'm still getting two columns with the same geography code. Grades 10 and 12 are under the first geocode "P" column and 11 grade under the second geocode "P"...

Danke!!! So close yet so far.

Yes

School, Membership_Days, Total_Attendance_days

Membership is the total number of school days to-date. I calculate the Total_Attendance_days by subtracting the daysabsent.

I ended up using the average function and a group by statement.

The data is in a read-only db for the last school.

All the 0.00 values are failing grades since they...

I ended up creating a SSIS package that did an addtional backed to the target server since I did know how to automate selecting the latest backup from a directory...