Then learn about normalizing SQL tables and that topic will pay dividends and solve the problem you are asking about. Normalize to 3rd normal form. Quote Report G ...

Basically, you’ll want to enable system-versioning for the source table to a history table which you’ve decided will be temporal. That being the case, you’ll need a couple additional columns of ...