I've been using a Synology NAS for the last 10 years, having only recently had to replace the HDDs due to the risk of failure being detected via the DSM...

Realised I can do this in Notepad++ before I import.

Press Ctrl+H to bring up the Find/Replace Dialog.
Choose the Regular expression option near the bottom of the dialog.
To...

I'm having to add back in the ISNULL on the percentage calculations so that NULL fields are not displayed.  SO example of an updated string is this.

            
March 23, 2023 at 4:26 pm
            
#4164230

            
            
                                                
        

I'm having to add back in the ISNULL on the percentage calculations so that NULL fields are not displayed.  SO example of an updated string is this.

ISNULL...

Thanks all.

Yeah I noticed the misspelling after I had posted the example above, all corrected now 🙂

SELECT[AT].[Site_Name] [Site Name]
,@Month01 [Month]
,COUNT ([AT].[Event_Code]) [Total Picks]
,COUNT (CASE WHEN [AT].[Event_Code] IN...

Thanks Ant-Green, just gave that a try and each of them comes up with a 0 value.  Here is some example data for a row where I've given the values...