Ahhh yes i see. Thanks again Jeff your help is greatly appreciated!

JS

Oh forgot to mention, Thanks Jeff Moden for writing the article 🙂

Good question! At first i actually didn't have access to the table and i couldn't imagine how many rows it would initialy have so i simply put 999999999999... When i...

Yes of course here is the script

Step 1 - Create the Tally Table

--=============================================================================

-- Setup. Duration - 00:02:31 Rows - 158,533,281

--=============================================================================

USE Source_Cleansed_DM

...

Hey MM, I've just finished my script and it works a treat!!! Thanks so much for your help 😀

Thanks MM. I've just finished reading the entire article and will start working on my sql now 🙂

If anyone already has a sql already done please feel free to post...

Also any hardcoded values can be excluded from the group by such as col1 below.

SELECT 'value' AS col1,

MAX(col2),

...