For the benefit of others, here is a consumable (and simplified) version of your set-up code. Please note in future how dates should be in 'YYYYMMDD' format (no need to...

Does this help? It relies on Jeff Moden's infamous splitter which, given the number of points you have, I imagine you've heard of.

DROP TABLE IF EXISTS #PipeStringTemp;

CREATE...

This does not appear to be a SQL Server post.

Also, is it a blog post, or do you have a question to ask?

If you expect a coded answer, please provide...

• This reply was modified 2 years, 1 months ago by Phil Parkin.

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...