the data type of schoolyear is nvarchar.

well, there's your problem. Convert it to an INT and you're good to go. (And for heaven's sake, fix all those stupid...

alternatively, you could push from within Access. created linked tables in Access to your SQL Server database(s). Create append queries that select data from the Access tables. Write a...

there are a bunch of SSRS tutorials from super simple to reasonably complicated on YouTube... look up WiseOwl. Worked for me. (because you can watch, stop, try, watch...)

create a whole bunch of linked SQL Server tables in your Access database.

Create queries to append the local table data to the backend SQL table.

then you could do something like

DBEngine(0)(0).Execute...

Best milkshakes ever. I don't like that boss very much.

Jeff,

I would agree the MCM is a different beast. It's more realistic (and difficult) than the standard multiple choice tests. Even I can pass those!

Certifications don't prove much, if anything. If I can get one, a trained monkey can.

There are several MVPs here in town (Joe, Dr SQL, Kevin...) and all of them have...

How do you get from your raw data to the result?

SELECT 1,'A',15,11,CAST('5/13/2015' AS DATE) UNION ALL

SELECT 1,'A',15,8,CAST('5/12/2015' AS DATE) UNION ALL

SELECT 1,'A',15,3,CAST('5/11/2015' AS DATE) UNION ALL

I see where the first...

"The first select is running fine but due to extra values added to the table the list of manual difined columns must be added manualy each time new values occur."

Simple...

If you have no other option, grab all the data, dump it to a temporary table, then remove any data you don't want.

One option...

SELECT *

FROM tbl

WHERE Change_Capture_Code !='00550'

AND Change_Capture_Code NOT BETWEEN '00560' AND '00580';

maybe add another column to your table and set its value in the stored procedure that adds the record.

And then just to yank Jeff's chain, I'd throw in a cursor to loop over the tables and run the truncate statement on each one...

Yeah, just teasing, but I...

Unless something completely escaped me, you can't do paging in T-SQL. You do that in the presentation layer (Reporting Services).

Maybe this is what you mean/need?

https://social.msdn.microsoft.com/forums/sqlserver/en-US/b84f651a-3770-4944-a9ef-7d175a8e4e88/running-procedure-against-multiple-databases