The best place to start is to look at the execution plans for the two queries. You can run profiler and see what is happening in each case. ...

By SCD, I am referring to a Slowly Changing Dimension.

Before jumping in and trying to build a data warehouse, I would recommend you get some training or at least a...

That would probably work, or you could put the "-" before the padding.

I think at some point, the mind decides that everything MUST be complicated just because everything to that point has been.

I am assuming that you could have an alpha character in the column. This being the case, if you want the semi-numeric sorting you can pad spaces to the...

Return the results of the procedure into a temp table or table variable

Granted, there are probably ways to call xp_executeSQL from a function.

I would never recommend doing any of them. You could do this with the CLR and I am...

Using expressions and/or variables

It is a data flow transformation task like a lookup, or derived column.

It is called "Slowly Changing Dimension" in the toolbox.

SSIS comes with a great task called the slowly changing dimension wzard.

This task will take a row in your data flow, determine by the primary key if the record already...

You have to use expressions

You cannot point SSIS at a database and tell it to wait for any data or schema changes and then populate a data warehouse.

There is an SCD wizard that will...

It can be done. In RS, you have two options that I can think of right now.

The easiest would be to use a report and a sub-report. Your...

That will actually depend on the RAID controller. I would suggest contacting the manufacturer.

No problem.

That was far easier to describe with pictures. I should have done that in the first place.