When you insert the copied rows...

Select DeveloperName, HitCount
from AppDevelopers
cross apply ufn_BigStick(AppDeveloperID)

GO 20

Why do you want to exclude the IDENTITY columns in the first place? If you use SET IDENTITY_INSERT <your table> ON you can copy the identity values across as well.

You can sum a nullable column. Rows where the column is null will not contribute to the total, so leaving the marks null when the student was absent (for whatever...

I'm assuming you can't use suser_name() or an equivalent because the application connects using a SQL Server login rather than windows authentication. You could prevent deletes, etc. from occurring outside...

I think the UserID variable in your code will be receiving the RETURN value from executing the stored procedure. This is not the same as the results of the SELECT...

Running multiple SQL statements passed in as a string.

This method looks highly vulnerable to SQL injection attacks.

"hiring to support growth" - what is that?

Are you able to change the parameter to a table-parameter? If so, you can add your array of values to it and use it in an inner join.

Just as an aside; I have got into the habit of using the "Script as create" instead of "Script as alter" or "Modify" options when looking at stored procedures, functions,...

Good article, but wouldn't the Post Code view containing the conditional elements return the whole postcode for parts 1 & 2 rather than blank when there is no space in...

At least the old adage has been proven - that any conversation left to run long enough on the internet will result in someone being likened to Hitler!

The structure proposed by tshad allows employees to flat-share. If you want overall flexibility, you need 3 tables; Employee, Address and EmployeeAddressLink. The start and end dates would then belong...

I have worked on a similar task before. The approach I took was to copy the names to another table (along with the primary key so I could link back...