Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • Reply To: Create New Table - Count Columns

    Thank you! How do I then create a table for this statement?

    August 10, 2021 at 1:16 pm

    #3918442

  • Reply To: Create New Table - Count Columns

    I tried below:

     

    select [candidateref],

    [candidatepostcode],

    Count([candidatepostcode]),sum(case when [candidatepostcode] IS NULL THEN 1 else 0 END) ,

    sum(case when [candidatepostcode] IS NOT NULL THEN 1 else 0 END)

    from [CandidateGeoLocation]

     

    but received the below error

     

    Msg 8120,...

    August 10, 2021 at 12:37 pm

    #3918415

Viewing 2 posts - 1 through 2 (of 2 total)