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

How absolutely up to date do you need your data? If you use caching, SSRS would load the report data once, and then used the cached data. ...

one option is to import into a staging table, then append the unique values to another table...

Amen to that.

There are the usually obvious cases where they should be avoided, but the cases where they're ideal is never really covered. It's like cursors are a bad word,...

Oh, c'mon... you've been around here long enough to know how to post data. Here's the table/inserts:

CREATE TABLE t1 (

n INT PRIMARY KEY,

note_ID INT,

Note_Serial_Num INT,

NoteStatus TINYINT);

INSERT INTO t1 VALUES...

I don't think certification proves anything at all. I know people who have written books on SQL Server, are MVPs, and don't have a single certification. My certs are...

Nope. When you use a template, SSRS basically copies the contents of the template to the new file. Old files are not affected.