Only shows NULL when using the variable which set with Scope_Identity() on JOIN statements in a stored procedure
After INSERT and setting a variable (@scopeID) with SCOPE_IDENTITY(), when I try to JOIN tables with @scopeID, I can only see the value of @scopeID, and other variables are NULL.