try this

;with data_cte
as    (
        SELECT

                A.Custom2 as State,
                Case
                    when A.Defecttype = 'BUG' then 1 else 0
                end as BCNT,
                Case
                    when A.Defecttype = 'ENHANCEMENT'...

Mark Cowne

Here is what my expected results are meant to look like for both sample clients
1

...

Hi J Livingston,

Here is the revised script with the updated datetime values. he script is giving me error for the date conversion " conversion failed when converting date...

Hi Mark Cowne,
Thanks for the response, i have reviewed...

Hi J Livingston SQL,  thanks for your response. the...

Hi Ed,

Thanks for the tip. I have updated the script using Print, which showed me there was a missing ] at the end of my script afterthe last @PivotCols+ which...

Thanks Lynn,

The procedure works now after taking your advice and ending the begins.

best wishes

A

Hi again lynn,

the error message is

Msg 102, Level 15, State 1, Procedure ReferralsDynamicPivot, Line 53

Incorrect syntax near ';'.

......

Here is my attempt at convertring it to a proc

Thanks for your...