Sorry  not able to replicate the issue.  The OP code relies on implicit conversion between INT and NVARCHAR which generally works but is an error prone (and awful for the...

TRIGGER_NESTLEVEL?  I usually try to persuade novices out of it.  Maybe the non-INSTEAD OF triggers could ask themselves: "Have I been executed at an inappropriate nest level?"

The textbooks say writing your own loops in relational database code is something to be avoided.  Are you sure it's necessary to write loops?

SGAB, does any one have a decent example of an Instead Of Update trigger that will handle more than one bloody row at a time and also ONLY update...

To generate sample data you could use a Tally table and calculate a datetime column.  This generates 400 rows and calculates a column 'sample_dt' which starts with the current...

• This reply was modified 3 years, 2 months ago by Steve Collins.
• This reply was modified 3 years, 2 months ago by Steve Collins.

Interesting and much appreciated.  Happy Thanksgiving!

If you load up one of the strings with a bunch of commas it causes an error afaik.  JSON doesn't care how many commas in a row.  A tiny point...

Comma is not an escape character in JSON (towards the bottom of the page) 😉

https://www.json.org/json-en.html

The "application" is out of support and yet the database is separate and updatable?  If at all possible I wouldn't touch a single thing.   If something breaks... better to treat...

Jeff's code seems to generate primary keys and produces the correct output afaik.  Creating foreign keys should be straightforward for the OP.  The split could be accomplished with OPENJSON without...

Why does this make sense?  CONVERT using style 2 seems to convert to text and removes the leading '0x'

select Modelnameid origignal
      ,cast(SUBSTRING(Modelnameid...

A good first step could be to run this code

select datepart(weekday, cast(getdate()+nums.n as date)) day_of_week_number, 
       datename(weekday, cast(getdate()+nums.n as date)) day_of_week
from...

Maybe you're looking for the SUM OVER the volume partitioned by the 'parent_id' column but which column is appropriate to ORDER BY?  If ORDER BY the 'filter_path' column it causes...

It's true.  It's available in Azure SQL compatibility level 150 (and above) and SQL Server 2022.  There are alternatives such...

drop table if exists #some_table;
go
create table #some_table (
  input_string varchar(200) not null);

insert #some_table(input_string) values
('5,1,6,1,69,1'),
('5,1,6,1,3,2,5,3,69,1');

select string_agg(iif((ss.ordinal-1)%2=0, concat('''', ss.[value], ''''), ss.[value]), ',')
      ...