Please post table scripts, sample data and expected output. It's easy, promised 🙂
See http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/ for guidance.

I suppose that you have been told to avoid taking backups with TRUNCATE_ONLY, because they break the log chain. Shrinking the log is a totally different operation, that (while potentially...

You should load a staging table with the new (id,name) pairs and then updat the target table from the staging table.
Something like this:
UPDATE targ
SET name...

First unpivot, then pivot:

IF OBJECT_ID('tempdb..#test') IS NOT NULL
DROP TABLE #test;

CREATE TABLE #test(
   populationtypedescription varchar(10)
 ...

Spam, reported

Spam

SQLBrowser returns the list of instances on a machine and the protocols+protocol details of a given instance.
You will need it whenever:
1) You are trying to connect to a...

Reported

It looks like the stored procedure was not created correctly.

Do not attempt to run the .sql file directly from Adam's .zip archive: extract it to a temp folder and open...

You can use my stored procedure template here: https://spaghettidba.com/2011/07/08/my-stored-procedure-code-template/

Then you just have to add the INSERT and SELECT statements that you need. Actually, with composable DML, you can achieve the...

Your description of the problem is a bit vague.

Which table will you be inserting data into? What set of parameters are you expeting? Where will the select statements pull...

Short answer: you can't.

Long answer: there is no way to tell whether a backup will restore succesfully or not and that alone is no guarantee that the backup does not...