Welcome to the life of "make the analysts lives better, but don't add additional steps to their existing processes." 🙂 I'm sure we have all been there. Anyway, breaking...
Sorry for the rather vague post. Here is some data that will hopefully provide more information. Say you start with table abc as follows CREATE TABLE [dbo].[abc](