处理空白查询结果ISNULL(NULLIF())

Im trying to return the results of a query into a variable to I am able to use it in a insert statement. However my select keeps returning null even though I believe I have the Im trying to return the results of a query into