Essentially unit testing and performance testing.

Thank you.  I tried out the EXEC statement and received an error.  I'm guessing it's because I don't have adequate permissions, like you said.

I would like to thank everyone for their help.  It was a very educational experience in using UPDATE and MERGE in Execute SQL Tasks. They work better (and faster) than...

Fortunately, we are using SQL Server 2016.  Have you used temporal tables in a Type 2 SCD situation?  How well does it work?  Also, how does it impact reporting against...

So the Slowly Changing Dimension object turned out to be \"less than ideal\" (in other words, trash). Where is a good place for me to learn how to implement an...

Thanks for pointing me in the right direction.

Let me re-phrase:

1) Set the variable equal to the parameter,

2) If variable is null because the parameter is null, Then set the variable equal to the SELECT statement,

3) Else variable...

Here's another idea:

In the Execute SQL Task, can we check to see if the parameter has a null value?  If it does, then we can SELECT the max(date).  If the...

Let me try to explain better.

1.  Under normal conditions, the Execute SQL Task will get the max(date) and assign it to a variable.
2. But under certain conditions, we want to...

Okay, so let's say we use the MERGE statement instead of an SCD object.  How do I get data from the preceding step in the SSIS package (a Derived Column...

I totally agree that the SCD object is far from ideal.  However:  1) the data set is very small (just a few hundred megabytes of data), 2) we are under...

But could the same thing be done with a UDF?

Okay, that makes sense.

If my clients mention they want to use a stored procedure as a source for star schema data warehouse reporting, I can explain why that might not...

I see your point.  However, isn't the point of a star schema to simplify things so you don't need complex joins?  Why would you need to have a view joined...

This is good information.  My question now is, why even use a UDF as a source for a report?  Why not just have the report user access a view and...