Only shows NULL when using the variable which set with Scope_Identity() on JOIN statements in a stored procedure
Understanding SCOPE IDENTITY and JOIN Statements in SQL Stored Procedures When working with SQL stored procedures you might encounter a frustrating issue where