NOLOCK is a no-no... don't do that unless you're aware of the nasty side effects.

here's a hint:

GETDATE() returns the current date.

Right-click your date parameter > Parameter Properties.

Available Values > Get values from Query , then choose the dataset and the value and label fields.

Same as any other dropdown in SSRS.

I think it's an XOR thing...

Either you can select a date (no list of values)... and you can use the Calendar control

OR

You can select a date from a dropdown.

you can't...

This is a partial answer, but if you want to learn data warehousing and understand what you're doing, read Ralph Kimball's Data Warehouse Toolkit, and read Adamson's Star Schema: Complete...

Exercise your Googlefu, young Jedi!

https://msdn.microsoft.com/en-us/library/ms190307.aspx

Does database B already have data in it? If not, it would be easier to restore A over B.

Interesting metric... How much sh*t do you feel comfortable being covered with when it hits the fan? More frequent log backups and full backups minimize the stink...

Alex,

You'd just do something like

SET NOCOUNT ON;

INSERT INTO DestTable

SELECT [fieldlist] FROM SrcTable WHERE...

in your stored procedure and then just call it in a job that you schedule.

Alex,

this part: "What I want to do is have the data populate from the nightly run into a SQL table (already created) each night at least 4 rows will get...

Was it removed in 2016? I didn't really ever use it much... just never had a reason to.

That said, anybody know what MS's plans are with reporting? It seems...

First off, this is an Integration Services question. You would create all the steps there and run it via a Job. I think you just posted in the wrong...

Got Google?

http://www.sqldbadiaries.com/2010/10/22/generate-scripts-for-linked-servers/

Faulty reasoning on his part in my opinion. They're just different.

Can't you just change the font color property value to an expression?