This took a while, but was fun! There are a couple of characters in this forum who like to come along and make my code run 17 times faster, with...

Do you want a single-cell result, rather than multiple columns?

I don't have time to answer right now, but would like to congratulate you on writing such a clear and detailed question, especially as you are new here … well...

SELECT ID
      ,Name = CONCAT ('''', Name, '''')
      ,City = CONCAT ('''', City, '''')
FROM #tbl_Test;

Here is a cut-down example, which you should be able to expand to do what you want. There is much that can be done to refine it, but as it...

A table-valued function might do what you need. Have a look at the following link and see whether it gets you on the way:

https://www.sqlservertutorial.net/sql-server-user-defined-functions/sql-server-table-valued-functions/

As you've no doubt already discovered,...

Best guess. Please provide your sample data in consumable format in future.

DROP TABLE IF EXISTS #Somedata;

CREATE TABLE #SomeData
(
    Id INT
   ,SomeData VARCHAR(50)
...

How are you ordering the data? I do not see what makes the second row come after first.

Thanks @Phil

I've just looked and foreign keys are set to TRUE which is odd.

I'll keep an eye on it and see if it happens again.

I'll also go through the...

I've only seen it when using the designer.

Can you point in the direction of the specific (if there is one) default that needs changing to stop this happening?

I've had...

Hello,

Of course the COMMIT TRAN have been put within IF and the same has been deployed already.

The question here is why in first couple of days this error did...

stp = Stored Procedure?

I suspect 'simulated' is not the right word here ... but I'm not sure what you really mean. Please clarify.

What to be done? Fix the bug! You...

Thanks for that.   We use synonyms to refer to other databases so hopefully that shouldn't cause too many issues.

I'll give it a go with a test database and...

Should be...

If you've got this all inside a VS database project, editing the .sql files for the tables and then Publishing does everything for you.

But behind the scenes, it is still...