You indicated BillingRateB was blank, but in the picture it is BillingTypeB that is blank -- Rate (which is either BillingRateA or BillingRateB) is always populated. But there are...

So the count returned is right.

Can you provide one or more sample source rows and corresponding output rows (obfuscated as appropriate) where the problem lies?

Since you are aliasing BillingRateA as 'Rate' and BillingRateB as 'Rate', are you saying that you are seeing a populated Rate column when you run just the bottom half, but...

A primary key is really just a unique index (clustered or not, depending on how it was created). Microsoft has wrapped it w/ some logic that syntactically implements it as...

Short of writing your own dtsx processor, there is no way to run dtsx packages without SSIS. dtexec is the executable that parses & implements the logic in dtsx...

No. If you really need/want to convert the unique index to a primary key, you will have to drop the index and create the primary key - I don't believe...

You have a very good vendor.

How to post code problems

• People trying to help you are donating their time. Providing scripts to create tables, views, procedures, etc. and populate data saves them time in...

• Your DDL script is wrong. You have specified your primary key on a column "index" that doesn't exist in your table definition.
• Why are all your columns except ID...

If you are running certain queries frequently, turn them into stored procedures. Then they will be saved in SQL Server and accessible through the object explorer. And stored procedures...

No. It's no longer available. Microsoft has once again killed a feedback site for SQL Server.

It is often the case that persisting working data can improve performance, and probably won't take long to test this anecdotally, so I wouldn't discourage trying it. But long term...

You can only create indexes on views if they met certain criteria: https://docs.microsoft.com/en-us/sql/relational-databases/views/create-indexed-views?view=sql-server-ver15

Indexed views are only valuable in limited circumstances. If you've already created indexes on the table that allowed...

What do you mean by "customized" log shipping?

Are you trying to do a timed drill to estimate recovery time, or just trying to prove you can failover successfully?

You ask for...

You can insert the data into a user-defined table type variable , add a table-valued parameter (TVP) to the second procedure referencing that table type, and pass the variable from...