Either of these should work fine...

SELECT

    fcid

    ,species

    ,ISNULL([abam], 0) AS [abam]

    ,ISNULL([psme], 0) AS [psme]

    ,ISNULL([arme], 0) AS [arme]

FROM

   ...

Change your join from JOIN to INNER JOIN.

JOIN by itself is a LEFT JOIN which pulls all records from the left table (HOLDING in your case) and only the records...

Mark,

DDL is "Data Definition Language" such as

CREATE TABLE [dbo].[AUDIT](

      [AUDITID] [int] NOT NULL,

      [PARTYID] [int] NOT NULL ………

To get the DDL for existing tables, right click on...

Joe,

I understand your point, the question could/should have been posted with more info, but it WAS enough information to give an answer to.

Again, there could have been more useful info...

Mark,

It is a Newbie forum. That's why I Only gave one suggestion on future posts. You'll pick it up as time goes buy...

Sorry Joe, Not trying to slam you here,...

UPDATE d

    SET d.dcol3 = s.scol2

        ,d.dcol5 = 'Y'

    FROM dest_tbl d

        INNER JOIN src_tbl s

            ON d.dcol2 = s.scol1

    WHERE

       ...

Read up on the PIVOT keyword in BOL.

🙂

Happy to help.

You didn't include the table def for the "CSCounty" table But this should do the trick

UPDATE CSZ

    SET SFZipIndexCode = SFMSAindexcode