Question Details

No question body available.

Tags

sql-server t-sql sql-update aggregate-functions common-table-expression

Answers (1)

Accepted Answer Available
Accepted Answer
June 11, 2026 Score: 4 Rep: 182,954 Quality: High Completeness: 70%

The issue is CAST(NULL AS bit) AS CNIDRecordCount

SELECT     CAST(115704   AS INT) AS ConflictNoticeID
     , CAST(16003573 AS INT) AS MerchantID
     , CAST(13       AS INT) AS WebUserID
     , CAST(NULL     AS bit) AS CNIDRecordCount   --   here
INTO #Tab2And3Pop

It should be: CAST(NULL AS INT) to avoid an implicit conversion.

Rationale: bit data type:

Converting to bit promotes any nonzero value to 1.