The command wouldn't work anyway, as you noted, but just to point it out, you wouldn't be trying to add the new primary key to the backup table anyway, since...

How does USP_GetVariance work when @Operation is NULL, as it will be here? That variable is declared but never assigned a value.

Cheers!

Yeah, that's a very similar approach to dova's from the comments of the original article (I mentioned his solution briefly in my last post), but performs even a bit better...

I've been doing some testing of the other solutions in the article and comments (still have some to go, including another from Peso that might beat the rest).

Peso's...

I've been working on an alternate solution to this one for a while. I have one, but it's somewhat ugly, and while it reads the base table only once, it's...

To pile on, this CustNameXRef object referenced in those procedures, is it a view?

If so, could we see its definition as well?

Cheers!

EDIT: Your most...

The devil's in the details, unfortunately, and those are hidden from us.

Instead of an incredibly obscured screenshot, just put up an anonymized script.

Substitute something with...

I don't have access to an appropriate server to test, but msdb.dbo.sysjobsteps should have a reference  to the package used in the command column.

Could just query for command...

Keep in mind that SQL Server uses a proportional fill algorithm for allocation.

Allocations to files in a filegroup will be roughly proportional to the amount of free space...

Happy to help, and glad you got it figured out!

Cheers!

With the sample data you provided, I don't get results from either form, whether the date is hardcoded or pulled from OT_Jacob, primarily because there's only one row in that...